We help IT Professionals succeed at work.

sybase 15.7 increase and create new default data cache

telliot79
telliot79 asked
on
Experts,

I've built a windows sybase 15.7 server using pretty much all the defaults. I've noticed that my default data cache only has  a 2K I/O Buffer Pool and it's set to 8MB. I want to increase this, and also create a 4K and 16K Buffer Pool. How would i do this?

Thanks in advance,

Comment
Watch Question

figured it out:

configured max memory:

sp_configure "max memory", 1310720

then inceased default data cache:

sp_cacheconfig "default data cache", '100M'

then added new cache

USE master
go
EXEC sp_poolconfig 'default data cache','25K','4K','2K'
go

Author

Commented:
figured it out myself once i figured the right questions to ask google.