Most rows represent a specific type of activity or event, such as acquiring a lock or executing a stored procedure. When the data is related to CPUs, the rows show performance information for each Adaptive Server engine in the SMP environment. Often, when there are groups of related rows, the last row is a summary of totals and an average.
The sp_sysmon report indents some rows to show that one category is a subcategory of another. In the following example, “Found in Wash” is a subcategory of “Cache Hits”, which is a subcategory of “Cache Searches”:
Cache Searches per sec per xact count % of total ---------- --------- ------- -------- Cache Hits 32731.6 153429.6 9819492 100.0 % Found in Wash 288.4 1351.7 86508 0.9 % Cache Misses 10.9 50.9 3257 0.0 % --------------------- ------------ --------- --------- Total Cache Searches 32742.5 153480.5 9822749
Many rows are not printed when the “count” value is 0.