sp_sysmon report includes these enhancements:
New categories in the Task Management section. These new rows identify context switches related to different types of lock acquisition. For example:
Task Management per sec per xact count % of total -------------------- -------- -------- ------ ---------- ... Text Context Switches Due To:
... Physical Lock Transition 208.9. 0.4 26108 4.6% Logical Lock Transition 2209.3 4.5 276160 48.5% ... Interconnect Message Sleeps 612.2 1.2 76527 13.5%
New “Grabbed Locked Buffer” output in the Pool Turnover section. Grabbed Locked Buffer displays the percentage of buffers grabbed with a physical lock. For examplet:
Task Management per sec per xact count % of total -------------------- -------- -------- ------ ---------- ... Pool Turnover 4 Kb Pool LRU Buffer Grab 89.2 0.2 11154 100.0% Grabbed Locked Buffer 0.0 0.0 0 0.0% Grabbed Dirty 0.0 0.0 0 0.0% --------------- ------- ------- ------ Total Cache Turnover 89.2 0.2 11154
