Lock Overview by Lock Type

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 nameDescription
Exclusive Extent LocksNumber of exclusive extent locks
Exclusive Intent LocksNumber of exclusive intent locks
Exclusive Page LocksNumber of exclusive page locks
Exclusive Table LocksNumber of exclusive table locks
Shared Intent LocksNumber of shared intent locks
Shared Page LocksNumber of shared page locks
Shared Table LocksNumber of shared table locks
Update Extent LocksNumber of update extent locks
Update Page LocksNumber of update page locks