ASA SQL User's Guide
  Monitoring and Improving Performance
    Using the cache to improve performance

Monitoring cache size

The following statistics have been added to the Windows Performance Monitor and to the database's property functions.

• CurrentCacheSize    The current cache size in kilobytes

• MinCacheSize    The minimum allowed cache size in kilobytes

• MaxCacheSize    The maximum allowed cache size in kilobytes

• PeakCacheSize    The peak cache size in kilobytes

For more information on these properties, see Server-level properties.

For information on monitoring performance, see Monitoring database performance.