Sybase Tuning for ASE 12.5

各參數說明:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc31654.1570/html/sag1/X68714.htm

以下為IBM Cognos of IBM infocenter 提供的調整建議

http://pic.dhe.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.vvm_ag_guide.10.1.0.doc%2Fvvm_ag_guide_id6415Vv_sybase_config.html

IMDB /

#Configure memory and cache in Sybase ASE 12.5

sp_configure 'max memory', 8192M

go

sp_configure 'lock shared memory', 1

go

sp_cacheconfig 'default data cache', '1024M'

go

sp_cacheconfig 'procedure cache', '128M'

go

sp_cacheconfig 'cache01', '80M'

go

#Configure processing limits in Sybase ASE 12.5

sp_configure 'number of user connections', 1024

go

#default 10 worker processes

sp_configure 'number of worker processes', 100

go

sp_configure 'max parallel degree', 3

go

sp_configure 'max scan parallel degree', 3

go

sp_configure 'number of locks', 100000

go

sp_configure 'number of open objects', 50000

go

sp_configure 'number of open databases', 32

go

#relevent to No# of file descriptors

sp_configure 'number of devices', 32

go

#Configure network parameters in Sybase ASE 12.5

sp_configure 'additional network memory', 8192

go

sp_configure 'max network packet size', 4096

go

sp_configure 'default network packet size', 2048

go

sp_configure 'heap memory per user', 4096

go

--
最後發現是以下參數最重要...
--減少query plan產生的時間
--select CustName from Customers where CustID = 123
--select CustName from Customers where CustID = 456
--以上兩句SQL 共用以下的plan
--select CustName from Customers where CustID=

sp_configure 'enable literal autoparam', 1
go

--增加cache
sp_configure 'statement cache size', 5000

go

--

IMDB : inmemory_storage tuning