Sample output

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 %
Cluster Locks Retained              0.0           0.0           0       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


Cluster Lock Summary            per sec      per xact       count   % of total
------------------------   ------------   -----------   ---------   --------- 

Physical Locks Summary          per sec      per xact       count   % of total
------------------------   ------------   -----------   ---------   --------- 
No physical locks are acquired

Logical Locks Summary           per sec      per xact       count   % of total
------------------------   ------------   -----------   ---------   --------- 

Object Locks Summary            per sec      per xact       count   % of total
------------------------   ------------   -----------   ---------   --------- 

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.