Tuning Sybase ASE
The discussion in this section focuses on Sybase System 11 and subsequent releases (System 11.5, 11.9.2, 12, and 12.5). Although the same basic principles apply to System 10 and earlier releases, not all features are available.
Tuning Memory
ASE 12.5 supports dynamic changes to the shared memory segment size. We consider this functionality and conclude with general memory tuning recommendations.
Dynamic Memory Tuning
Before ASE 12.5, the amount of shared memory could not be changed dynamically—a database restart was required after the parameters were changed. The total memory parameter, grouped under Physical Memory in the configuration file, determined the size of shared memory. Memory was allocated to named data caches ...
Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
