Lock Detail

Overview

The Lock Detail 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 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
DBIDDatabase ID 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
Page #Number of pages allocated to lock resource
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
Session DetailDisplays detailed information related to resource usage in each session. To display this report, click the SPID field.