Lock Overview (6.0)
- Organization of this page
Overview
The Lock Overview (6.0) 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 (6.0) |
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 (6.0) |
Displays information related to sessions that have locks that are blocking other sessions. To display this report, click the Total Blocking Locks field. |