sp_sysmon reports on cache hits and misses for:
All caches on Adaptive Server
The default data cache
Any user-configured caches
The server-wide report provides the total number of cache searches and the percentage of cache hits and cache misses.
See “Cache statistics summary (all caches)”.
For each cache, the report contains the number of cache searches, cache hits and cache misses, and the number of times that a needed buffer was found in the wash section.
