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 94.8 0.8 5730 10.6 %
Engine 1 94.6 0.8 5719 10.6 %
Engine 2 92.8 0.8 5609 10.4 %
Engine 3 105.0 0.9 6349 11.7 %
Engine 4 101.8 0.8 6152 11.4 %
Engine 5 109.1 0.9 6595 12.2 %
Engine 6 102.6 0.9 6201 11.4 %
Engine 7 99.0 0.8 5987 11.1 %
Engine 8 96.4 0.8 5830 10.8 %
------------------------- --------- --------- -------
Total Task Switches: 896.1 7.5 54172
Task Context Switches Due To:
Voluntary Yields 69.1 0.6 4179 7.7 %
Cache Search Misses 56.7 0.5 3428 6.3 %
System Disk Writes 1.0 0.0 62 0.1 %
I/O Pacing 11.5 0.1 695 1.3 %
Logical Lock Contention 3.7 0.0 224 0.4 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.1 0.6 17 0.0 %
Log Semaphore Contention 51.0 0.4 3084 5.7 %
PLC Lock Contention 0.0 0.0 2 0.0 %
Group Commit Sleeps 82.2 0.7 4971 9.2 %
Last Log Page Writes 69.0 0.6 4172 7.7 %
Modify Conflicts 83.7 0.7 5058 9.3 %
I/O Device Contention 6.4 0.1 388 0.7 %
Network Packet Received 120.0 1.0 7257 13.4 %
Network Packet Sent 120.1 1.0 7259 13.4 %
Other Causes 221.6 1.8 13395 24.7 %
