Tuning named caches

Creating named data caches and memory pools, and binding databases and database objects to the caches, can dramatically hurt or improve Adaptive Server performance. For example:

When tuning named caches, always measure current performance, make your configuration changes, and measure the effects of the changes with similar workload.