Rows

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.