星期一, 8月 12, 2013

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

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...