Lock Detail (PD_LD)

Function

The Lock Detail (PD_LD) record indicates detailed information related to database locks. One record is created for each database lock. This is a multi-instance record.

If you collect the Lock Details (PD_LD) record when a large number of transactions or access locks have occurred in the Microsoft SQL Server, the following events might occur.

For example, when number of locks temporarily increases during backup of the SQL Server databases, you can set the upper limit by using the LIMIT_PD_LD_NUMBER item in the instance information to reduce system load.

For details about the LIMIT_PD_LD_NUMBER item, see 2.1.4(2)(b) Set the monitoring target.

Note:
PFM - RM for SQL Server collects performance data of the record field size from Microsoft SQL Server. Therefore, if Microsoft SQL Server contains data that exceeds the field size of Program field or Table field or User field, the last character of the performance data might be unreadable.

Default and changeable values

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key field

Lifetime

From the start until release of a lock

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
Blocking Flag(BLOCKING)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
--wordNomaster..syslockinfo.req_status
DB Name
(DB_NAME)
Database name related to lock resource--string(257)Nodb_name(master..syslockinfo. rsc_dbid)
DBID
(DBID)
Database ID related to lock resourceCOPYwordNomaster..syslockinfo.rsc_dbid
Demand Flag
(DEMAND)
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
--wordNomaster..syslockinfo.rsc_type, master..syslockinfo.
Lock Type
(TYPE)
Lock type (lock request mode and lock resource type)--string(80)Nomaster..syslockinfo.req_mode
Orphan Flag
(ORPHAN)
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
--wordNomaster..sysprocesses
Page #
(PAGE)
Number of pages allocated to the lock resource--ulongNomaster..syslockinfo.rsc_text
Program
(PROGRAM)
Name of the application program that is requesting the lock--string(257)Nomaster..sysprocesses.program_name
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always LD)--char(8)NoRemote Monitor Collector
SPID
(SPID)
Process ID that is requesting the lock--wordNomaster..syslockinfo.rsc_spid
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Table
(TABLE)
Table name if the lock resource is a table or row--string(257)Nosys.all_objects.name in the row that satisfies the condition master.sys.dm_tran_locks.resource_associated_entity_id = master.sys.all_objects.object_id for each database.
User
(USER)
Logon name of the user who issued the command--string(61)Nomaster..sysprocesses, master..syslogins
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector