Cache hit ratio information from sp_sysmon

sp_sysmon reports on cache hits and misses for:

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.

See “Cache management by cache”.