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.

Reports/RM SQLServer/Troubleshooting/Real-Time/

Lock Detail (PD_LD)

Field name	Description
Blocking Flag	This 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 Name	Database name related to lock resource
Demand Flag	This 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 Type	Lock type (lock request mode and lock resource type)
Orphan Flag	This flag indicates whether or not the lock is an isolated lock. The following values are valid: 1 Isolated lock 0 Not an isolated lock
Program	Name of the application program that is requesting the lock
SPID	Process ID that is requesting the lock
Table	Table name if the lock resource is a table or row
User	Logon name of the user who issued the command

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