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:
Spinlock contention
Utilization
Cache searches, including hits and misses
Pool turnover for all configured pools
Buffer wash behavior, including buffers passed clean, buffers already in I/O, and buffers washed dirty
Prefetch requests performed and denied
Dirty read page requests
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.