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%
