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.

• Space in the Store database increases.
• Collection takes time, and until the collection has been completed, the collection of other records is skipped.
• A large amount of memory is consumed.

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.

Item	Default value	Changeable
Collection Interval	60	Y
Collection Offset	0	Y
Log	No	Y
LOGIF	(Blank)	Y

• PD_LD_DB_NAME
• PD_LD_DBID
• PD_LD_SPID

From the start until release of a lock

• Fixed part: 681 bytes
• Variable part: 926 bytes

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: 1 Blocking lock 0 Not a blocking lock	--	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: 1 Request lock 0 Not a request lock	--	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: 1 Isolated lock 0 Not an isolated lock	--	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