ASE : Server Configuration - example for 64 bit ASE

It is difficult to get an actual example of a system config from Sybase support. Here is
such a configuration, for a Sun server with 12 GB memory, running only an ASE 12.5 64-bit server.
There are 8 databases, each 5 - 18 GB in size.

-- Server Note: shared memory is set to 11500000000 (11.5 GB)
-- shared segments is set to 20


-- Set procedure cache to 500mb

sp_configure 'procedure cache size',500000
go
sp_configure 'cpu grace time', 1000
go


-- 10 GB max memory

sp_configure 'max memory', 10000000
go


-- Set up 32K pool for this financial table, that has an image column

sp_poolconfig 'cache02', '300M', '32K'
go
sp_bindcache 'cache02','account_db','base_account_finanacial_data'
go


-- Default data cache config - this is critical! 8 GB

sp_cacheconfig 'default data cache','8000M'
go