Sample output
Task Management per sec per xact count % of total
-------------------------- ------------ ---------- -------- ----------
Connections Opened 0.2 0.0 154 n/a
Task Context Switches by Engine
Engine 0 269.9 3.4 240477 7.3 %
Engine 1 209.4 2.7 186574 5.7 %
Engine 2 198.4 2.5 176730 5.4 %
Engine 3 198.5 2.5 176859 5.4 %
Engine 4 278.4 3.5 248054 7.5 %
Engine 5 187.1 2.4 166697 5.1 %
Engine 6 202.7 2.6 180640 5.5 %
Engine 7 312.2 4.0 278129 8.5 %
Engine 8 215.7 2.7 192198 5.8 %
Engine 9 260.3 3.3 231940 7.1 %
Engine 10 235.1 3.0 209447 6.4 %
Engine 11 409.2 5.2 364604 11.1 %
Engine 12 225.8 2.9 201166 6.1 %
Engine 13 484.9 6.1 432020 13.1 %
------------------------- ------------ ------------ ----------
Total Task Switches: 3687.5 46.7 3285535
Task Context Switches Due To:
Voluntary Yields 860.8 10.9 766929 23.3 %
Cache Search Misses 852.0 10.8 759122 23.1 %
System Disk Writes 12.7 0.2 11353 0.3 %
Exceeding I/O batch size 184.7 2.3 164550 5.0 %
Logical Lock Contention 0.3 0.0 258 0.0 %
Address Lock Contention 0.0 0.0 12 0.0 %
Latch Contention 0.7 0.0 587 0.0 %
Log Semaphore Contention 31.1 0.4 27737 0.8 %
PLC Lock Contention 0.6 0.0 577 0.0 %
Group Commit Sleeps 6.9 0.1 6122 0.2 %
Last Log Page Writes 71.4 0.9 63619 1.9 %
Modify Conflicts 19.9 0.3 17728 0.5 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 152.1 1.9 135483 4.1 %
Network Packet Sent 643.7 8.1 573528 17.5 %
Network services 127.8 2.3 7564 8.9 %
Other Causes 850.7 10.8 757930 23.1%