Blocked Sessions

Overview

The Blocked Sessions report displays the information related to sessions that are waiting for lock release by other sessions. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.

Note that the performance of a session that repeatedly waits for lock release declines.

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.