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 name | Description |
---|---|
Blocking Flag | This flag indicates whether or not the lock is a blocking lock. The following values are valid:
|
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:
|
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:
|
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 |
Drilldown reports (field level)
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. |