Lock Overview by Lock Type
- Organization of this page
Overview
The Lock Overview by Lock Type report displays the overview of locks in the entire instance as the total number of database locks being maintained by lock type. This report is displayed as a list.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/
Record
Server Locks Detail (PD_LOCK)
Fields
Field name |
Description |
---|---|
Exclusive Extent Locks |
Number of exclusive extent locks |
Exclusive Intent Locks |
Number of exclusive intent locks |
Exclusive Page Locks |
Number of exclusive page locks |
Exclusive Table Locks |
Number of exclusive table locks |
Shared Intent Locks |
Number of shared intent locks |
Shared Page Locks |
Number of shared page locks |
Shared Table Locks |
Number of shared table locks |
Update Extent Locks |
Number of update extent locks |
Update Page Locks |
Number of update page locks |