Spotlight on SAP ASE 2.11 - User Guide

Cache Size chart

Use this chart to see how efficient your cache is sized.

Tuning for the efficient sizing of a server's data caches can have a dramatic effect on application response times. Poorly configured or sized caches can have the reverse effect on an Adaptive Server and related applications.

A cache that is under-utilized can indirectly hurt performance on the Adaptive Server and other applications. For example, if you allocate a high percentage of your data cache to a named cache that is not fully utilized, that memory is not available to the other data caches that might need it. As a result, the cache hit rates may be impacted with increased physical I/O.