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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
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) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Exclusive Extent Locks(EXTENT_LOCKS_EXCLUSIVE) | Number of exclusive extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Exclusive Intent Locks (INTENT_LOCKS_EXCLUSIVE) | Number of exclusive intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Exclusive Page Locks (PAGE_LOCKS_EXCLUSIVE) | Number of exclusive page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Exclusive Table Locks (TABLE_LOCKS_EXCLUSIVE) | Number of exclusive table locks | -- | ulong | No | master..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 | -- | ulong | No | master..sysprocesses.blocked |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always LOCK) | -- | char(8) | No | Remote Monitor Collector |
Shared Intent Locks (INTENT_LOCKS_SHARED) | Number of shared intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Shared Page Locks (PAGE_LOCKS_SHARED) | Number of shared page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Shared Table Locks (TABLE_LOCKS_SHARED) | Number of shared table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Total Blocking Locks (TOTAL_BLOCKING_LOCKS) | Number of locks that are blocking other processes | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Exclusive Locks (TOTAL_EXCLUSIVE_LOCKS) | Total number of exclusive locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Extent Locks (EXTENT_LOCKS_TOTAL) | Total number of extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Intent Locks (INTENT_LOCKS_TOTAL) | Total number of intent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Locks (TOTAL_LOCKS) | Total number of locks being used by Microsoft SQL Server | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Page Locks (PAGE_LOCKS_TOTAL) | Total number of page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Shared Locks (TOTAL_SHARED_LOCKS) | Total number of shared locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Total Table Locks (TABLE_LOCKS_TOTAL) | Total number of table locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Update Extent Locks (EXTENT_LOCKS_UPDATE) | Number of update extent locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Update Page Locks (PAGE_LOCKS_UPDATE) | Number of update page locks | -- | ulong | No | master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
Users Blocked (USERS_BLOCKED) | Number of users who are blocked by other users | -- | ulong | No | master..sysprocesses.blocked |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |