on 06-06-2016 6:24 AM
Hi,
I am speaking under correction but I recall this being correct when I had access to an ASE customer system. Which version and patch level of sybase and SAPKB are you running?
Kind Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I use below parameter for sybase DB.
sp_configure 'max memory', 0, '24G'
go
sp_configure 'procedure cache size', 0, '4G'
go
sp_configure 'number of sort buffers', 2000
go
sp_configure 'max online engine', 20
go
sp_configure 'number of user connections', 1000
go
sp_configure 'number of locks', 15000000
go
sp_cacheconfig 'default data cache', 'cache partition=16'
go
sp_configure 'statement cache size', 0, '500M'
go
sp_configure 'number of sort buffers', 2000
go
sp_configure 'max online engine', 20
go
WR,
Akshay
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.