This is a very tough question, and there are many variables, but the intent here is to provide a solid working example of how to tune and configure memory on a Sybase ASE 15.0.1 system supporting a VitalQIP IP Management System. This configuration is based on a Sun V120 w/ dual 1GHz CPUs w/ 4GB of RAM on Solaris 10. System shared memory and shared segments must be set up first. Shared Memory was set to 3.5GB and shared segments was set to 20. The following commands were issued immediately following the installation:
1> sp_configure 'procedure cache size', 128000 2> go 1> sp_configure 'max memory', 2800000 2> go 1> sp_poolconfig 'cache01', '100M', '8K' 2> go 1> use QIP 2> go 3> sp_bindcache 'cache01', 'QIP', 'obj_prof' 4> go 1> sp_cacheconfig 'default data cache', '800M' 2> go 3> sp_bindcache 'default data cache', 'QIP' 4> go
You will have to shutdown and restart the Sybase ASE dataserver. In fact, it is a good idea to reboot the system to ensure that the shared memory and shared segments get allocated properly and that the Sybase server comes up properly.