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)” on page 84 in the book Performance and Tuning: Monitoring and Analyzing for Performance.
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.
See “Cache management by cache” on page 89 in the book Performance and Tuning: Monitoring and Analyzing for Performance.
