Server Locks Detail (PD_LOCK)

Function

The Server Locks Detail (PD_LOCK) record indicates information related to Microsoft SQL Server locks. Only one record is created.

Default and changeable values

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

ODBC key field

None

Lifetime

From the start until stop of a Microsoft SQL Server instance

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
Exclusive Extent Locks(EXTENT_LOCKS_EXCLUSIVE)Number of exclusive extent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Exclusive Intent Locks
(INTENT_LOCKS_EXCLUSIVE)
Number of exclusive intent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Exclusive Page Locks
(PAGE_LOCKS_EXCLUSIVE)
Number of exclusive page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Exclusive Table Locks
(TABLE_LOCKS_EXCLUSIVE)
Number of exclusive table locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Max Users Blocked
(MAX_USERS_BLOCKED)
Maximum number of users who were blocked by other users during the monitored period--ulongNomaster..sysprocesses.blocked
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always LOCK)--char(8)NoRemote Monitor Collector
Shared Intent Locks
(INTENT_LOCKS_SHARED)
Number of shared intent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Shared Page Locks
(PAGE_LOCKS_SHARED)
Number of shared page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Shared Table Locks
(TABLE_LOCKS_SHARED)
Number of shared table locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
Total Blocking Locks
(TOTAL_BLOCKING_LOCKS)
Number of locks that are blocking other processes--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Exclusive Locks
(TOTAL_EXCLUSIVE_LOCKS)
Total number of exclusive locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Extent Locks
(EXTENT_LOCKS_TOTAL)
Total number of extent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Intent Locks
(INTENT_LOCKS_TOTAL)
Total number of intent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Locks
(TOTAL_LOCKS)
Total number of locks being used by Microsoft SQL Server--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Page Locks
(PAGE_LOCKS_TOTAL)
Total number of page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Shared Locks
(TOTAL_SHARED_LOCKS)
Total number of shared locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Total Table Locks
(TABLE_LOCKS_TOTAL)
Total number of table locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Update Extent Locks
(EXTENT_LOCKS_UPDATE)
Number of update extent locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Update Page Locks
(PAGE_LOCKS_UPDATE)
Number of update page locks--ulongNomaster..syslockinfo.rsc_type,master..syslockinfo.req_mode
Users Blocked
(USERS_BLOCKED)
Number of users who are blocked by other users--ulongNomaster..sysprocesses.blocked
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector