The following sample shows sp_sysmon output for the “Task Management” categories.
============================================================================= Task Management per sec per xact count % of total --------------------------- ------------ ------------ ---------- ---------- Connections Opened 0.0 0.0 0 n/a Task Context Switches by Engine Engine 0 0.6 16.5 66 100.0 % Task Context Switches Due To: Voluntary Yields 0.2 7.0 28 42.4 % Cache Search Misses 0.0 0.0 0 0.0 % System Disk Writes 0.0 0.0 0 0.0 % I/O Pacing 0.0 0.0 0 0.0 % Logical Lock Contention 0.0 0.0 0 0.0 % Address Lock Contention 0.0 0.0 0 0.0 % Latch Contention 0.0 0.0 0 0.0 % Log Semaphore Contention 0.0 0.0 0 0.0 % PLC Lock Contention 0.0 0.0 0 0.0 % Group Commit Sleeps 0.0 0.0 0 0.0 % Last Log Page Writes 0.0 0.0 0 0.0 % Modify Conflicts 0.0 0.0 0 0.0 % I/O Device Contention 0.0 0.0 0 0.0 % Network Packet Received 0.0 0.0 0 0.0 % Network Packet Sent 0.0 0.0 0 0.0 % Other Causes 0.3 9.5 38 57.6 %
