The following sample shows sp_sysmon output for the “Data Cache Management” categories. The first block of data, “Cache Statistics Summary,” includes information for all caches. sp_sysmon reports a separate block of data for each cache. These blocks are identified by the cache name. The sample output shown here includes only the default data cache, although there were more caches configured during the interval.
============================================================================= Data Cache Management --------------------- Cache Statistics Summary (All Caches) ------------------------------------- per sec per xact count % of total ------------ ------------ ---------- ---------- Cache Search Summary Total Cache Hits 0.1 3.8 15 100.0 % Total Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 0.1 3.8 15 Cache Turnover Buffers Grabbed 0.0 0.0 0 n/a Cache Strategy Summary Cached (LRU) Buffers 0.1 3.8 15 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage 0.0 0.0 0 n/a Large I/O Effectiveness Pages by Lrg I/O Cached 0.0 0.0 0 n/a Asynchronous Prefetch Activity 0.0 0.0 0 n/a Other Asynchronous Prefetch Statistics APFs Used 0.0 0.0 0 n/a APF Waits for I/O 0.0 0.0 0 n/a APF Discards 0.0 0.0 0 n/a Dirty Read Behavior Page Requests 0.0 0.0 0 n/a ----------------------------------------------------------------------------- Cache: default data cache per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Spinlock Contention n/a n/a n/a 0.0 % Utilization n/a n/a n/a 100.0 % Cache Searches Cache Hits 0.1 3.8 15 100.0 % Found in Wash 0.1 3.3 13 86.7 % Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 0.1 3.8 15 Pool Turnover 0.0 0.0 0 n/a Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 0.1 3.8 15 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Total Large I/O Requests 0.0 0.0 0 n/a Large I/O Detail No Large Pool(s) In This Cache Dirty Read Behavior Page Requests 0.0 0.0 0 n/a
