Lock Management --------------- Lock Summary per sec per xact count % of total ------------------------ ------------ ----------- --------- --------- Total Lock Requests 279236.5 6878.6 167541893 n/a Avg Lock Contention 1.2 0.0 691 0.0 % Deadlock Percentage 0.0 0.0 0 0.0 % Lock Detail per sec per xact count % of total ------------------------ ------------ ----------- --------- --------- Table Lock Hashtable Lookups 9571.4 235.8 5742818 n/a Avg Chain Length n/a n/a 0.00981 n/a Spinlock Contention n/a n/a n/a 0.2 % Exclusive Table Granted 14.3 0.4 8580 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Table Requests 14.3 0.4 8580 0.0 % Shared Table Total SH-Table Requests 0.0 0.0 0 n/a Exclusive Intent Granted 139.7 3.4 83793 100.0 % Waited 0.0 0.0 0 0.% ------------------------- ------------ ------------ ---------- ---------- Total EX-Intent Requests 139.7 3.4 83793 0.1 % Shared Intent Granted 9412.9 231.9 5647759 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Intent Requests 9412.9 231.9 5647759 3.4 % Page & Row Lock HashTable Lookups 173637.2 4277.3 104182335 n/a Avg Chain Length n/a n/a 0.01387 n/a Spinlock Contention n/a n/a n/a 0.4 % Exclusive Page Granted 306.5 7.6 183911 100.0 % Waited 0.0 0.0 2 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Page Requests 306.5 7.6 183913 0.1 % Update Page Granted 19052.6 469.3 11431583 100.0 % Waited 0.1 0.0 60 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Page Requests 19052.7 469.3 11431643 6.8 % Shared Page Granted 63587.2 1566.4 38152347 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Page Requests 63587.2 1566.4 38152347 22.8 % Exclusive Row Granted 33.9 0.8 20326 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Row Requests 33.9 0.8 20326 0.0 % Update Row Granted 10.1 0.2 6030 98.2 % Waited 0.2 0.0 108 1.8 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Row Requests 10.2 0.3 6138 0.0 % Shared Row Granted 88431.3 2178.4 53058781 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Row Requests 88431.3 2178.4 53058781 31.7 % Next-Key Total Next-Key Requests 0.0 0.0 0 n/a Address Lock Hashtable Lookups 98247.7 2420.2 58948613 n/a Avg Chain Length n/a n/a 0.00019 n/a Spinlock Contention n/a n/a n/a 0.5 % Exclusive Address Granted 2758.9 68.0 1655359 100.0 % Waited 0.6 0.0 380 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Address Requests 2759.6 68.0 1655739 1.0 % Shared Address Granted 95487.9 2352.2 57292733 100.0 % Waited 0.2 0.0 141 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Address Requests 95488.1 2352.2 57292874 34.2 % Last Page Locks on Heaps Granted 799.4 19.7 479637 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Last Pg Locks 799.4 19.7 479637 100.0 % Deadlocks by Lock Type per sec per xact count % of total ------------------------ ------------ ----------- --------- --------- Total Deadlocks 0.0 0.0 0 n/a Deadlock Detection Deadlock Searches 0.0 0.0 19 n/a Searches Skipped 0.0 0.0 0 0.0 % Avg Deadlocks per Search n/a n/a 0.00000 n/a Lock Promotions Total Lock Promotions 0.0 0.0 0 n/a Lock Timeouts by Lock Type per sec per xact count % of total ------------------------ ------------ ----------- --------- --------- Total Timeouts 0.0 0.0 0 n/a
“Lock Promotions” reports detail rows even if there were no occurrences of them during the sample interval; for example, “Deadlocks by Lock Type” in the above sample output.
