Lock Overview
Overview
The Lock Overview report displays the overview of locks in the entire instance as the total number of database locks being maintained. This report is displayed as a list. From the displayed report, you can display more detailed drilldown reports.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/
Record
Server Locks Detail (PD_LOCK)
Fields
Field name | Description |
---|---|
Total Blocking Locks | Number of locks that are blocking other processes |
Total Exclusive Locks | Total number of exclusive locks |
Total Extent Locks | Total number of extent locks |
Total Intent Locks | Total number of intent locks |
Total Locks | Total number of locks being used by Microsoft SQL Server |
Total Page Locks | Total number of page locks |
Total Shared Locks | Total number of shared locks |
Total Table Locks | Total number of table locks |
Users Blocked | Number of users who are blocked by other users |
Drilldown reports (report level)
Report name | Description |
---|---|
Lock Overview by Lock Type | Displays the overview of locks in the entire instance as the total numbers of database locks being maintained by lock type. |
Drilldown reports (field level)
Report name | Description |
---|---|
Blocked Sessions | Displays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Users Blocked field. |
Blocking Locks | Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Total Blocking Locks field. |