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
You can 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 the System Administration Guide for information on how to use these system procedures.
See “Configuring the data cache to improve performance” for more information on performance issues and named caches.
