Monitoring cache size

The following statistics are included in the Windows Performance Monitor and 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 about these properties, see Database server properties.

For information about monitoring performance, see Monitoring database performance.