Data Cache Management

sp_sysmon reports summary statistics for all caches, followed by statistics for each named cache.

sp_sysmon reports the following activities for the default data cache and for each named cache:

Use sp_cacheconfig and sp_helpcache output to help analyze the data from this section of the report. sp_cacheconfig provides information about caches and pools, and sp_helpcache provides information about objects bound to caches.

See Chapter 4, “Configuring Data Caches,” in System Administration Guide: Volume 2 for information on how to use these system procedures.

See Chapter 5, “Memory Use and Performance,” in Performance and Tuning Series: Basics for more information on performance issues and named caches.