Blocking Locks

Overview

The Blocking Locks report displays information related to sessions that have locks that are blocking other sessions. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.

Storage location

Reports/RM SQLServer/Troubleshooting/Real-Time/

Record

Lock Detail (PD_LD)

Fields

Field nameDescription
Blocking FlagThis flag indicates whether or not the lock is a blocking lock. The following values are valid:
1
Blocking lock
0
Not a blocking lock
DB NameDatabase name related to lock resource
Demand FlagThis flag indicates whether or not the lock is a request lock. The following values are valid:
1
Request lock
0
Not a request lock
Lock TypeLock type (lock request mode and lock resource type)
Orphan FlagThis flag indicates whether or not the lock is an isolated lock. The following values are valid:
1
Isolated lock
0
Not an isolated lock
ProgramName of the application program that is requesting the lock
SPIDProcess ID that is requesting the lock
TableTable name if the lock resource is a table or row
UserLogon name of the user who issued the command

Drilldown reports (field level)

Report nameDescription
Lock DetailDisplays detailed information related to each lock. To display this report, click the Lock Type field.
Session DetailDisplays detailed information related to resource usage status in each session. To display this report, click the SPID field.