Configuring and Tuning Databases on the Solaris™ Platform

Memory Management

Memory is managed within Sybase ASE by the Buffer Manager. ASE uses shared memory to hold the data cache, the procedure cache, and Sybase kernel data structures such as the run and sleep queues and lock chains.

Before ASE 12.5, changes to parameters affecting the size of shared memory did not take effect until a Sybase reboot. ASE 12.5 allows these parameters to be changed dynamically. For more detail, refer to “Dynamic Memory Tuning” on page 361.

Data Cache

Effective algorithms for caching data are critical for performance—when data is found in the cache, a physical read is avoided. The Buffer Manager’s job is to minimize the number of physical I/Os needed to execute any task. An effective Buffer Manager strategy combined ...