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 nameDescription
Total Blocking LocksNumber of locks that are blocking other processes
Total Exclusive LocksTotal number of exclusive locks
Total Extent LocksTotal number of extent locks
Total Intent LocksTotal number of intent locks
Total LocksTotal number of locks being used by Microsoft SQL Server
Total Page LocksTotal number of page locks
Total Shared LocksTotal number of shared locks
Total Table LocksTotal number of table locks
Users BlockedNumber of users who are blocked by other users

Drilldown reports (report level)

Report nameDescription
Lock Overview by Lock TypeDisplays 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 nameDescription
Blocked SessionsDisplays the information related to sessions that are waiting for lock release by other sessions. To display this report, click the Users Blocked field.
Blocking LocksDisplays information related to sessions that have locks that are blocking other sessions. To display this report, click the Total Blocking Locks field.