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.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key field
Lifetime
From the start until release of a lock
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Blocking Flag(BLOCKING) | This flag indicates whether or not the lock is a blocking lock. The following values are valid:
| -- | word | No | master..syslockinfo.req_status |
DB Name (DB_NAME) | Database name related to lock resource | -- | string(257) | No | db_name(master..syslockinfo. rsc_dbid) |
DBID (DBID) | Database ID related to lock resource | COPY | word | No | master..syslockinfo.rsc_dbid |
Demand Flag (DEMAND) | This flag indicates whether or not the lock is a request lock. The following values are valid:
| -- | word | No | master..syslockinfo.rsc_type, master..syslockinfo. |
Lock Type (TYPE) | Lock type (lock request mode and lock resource type) | -- | string(80) | No | master..syslockinfo.req_mode |
Orphan Flag (ORPHAN) | This flag indicates whether or not the lock is an isolated lock. The following values are valid:
| -- | word | No | master..sysprocesses |
Page # (PAGE) | Number of pages allocated to the lock resource | -- | ulong | No | master..syslockinfo.rsc_text |
Program (PROGRAM) | Name of the application program that is requesting the lock | -- | string(257) | No | master..sysprocesses.program_name |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always LD) | -- | char(8) | No | Remote Monitor Collector |
SPID (SPID) | Process ID that is requesting the lock | -- | word | No | master..syslockinfo.rsc_spid |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Table (TABLE) | Table name if the lock resource is a table or row | -- | string(257) | No | sys.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) | No | master..sysprocesses, master..syslogins |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |