Lock Detail (6.0)
- Organization of this page
Overview
The Lock Detail (6.0) report displays detailed information related to each lock. This report is displayed as a list. It is a drilldown report. From the displayed drilldown report, you can display more detailed drilldown reports.
Storage location
Reports/RM SQLServer/Troubleshooting/Real-Time/Drilldown Only/
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 |
DBID |
Database ID 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:
|
Page # |
Number of pages allocated to lock resource |
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 |
---|---|
Session Detail (6.0) |
Displays detailed information related to resource usage in each session. To display this report, click the SPID field. |