Server Locks Detail (PD_LOCK)
- Organization of this page
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 |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key field
None
Lifetime
From the start until stop of a Microsoft SQL Server instance
Record size
-
Fixed part: 757 bytes
-
Variable part: 0 bytes
Fields
|
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
|---|---|---|---|---|---|---|
|
Microsoft SQL Server version 2014 or earlier |
Microsoft SQL Server version 2016 or later |
|||||
|
Exclusive Extent Locks(EXTENT_LOCKS_EXCLUSIVE) |
Number of exclusive extent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Exclusive Intent Locks (INTENT_LOCKS_EXCLUSIVE) |
Number of exclusive intent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Exclusive Page Locks (PAGE_LOCKS_EXCLUSIVE) |
Number of exclusive page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Exclusive Table Locks (TABLE_LOCKS_EXCLUSIVE) |
Number of exclusive table locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_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 |
sys.dm_exec_requests.blocking_session_id |
|
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 |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Shared Page Locks (PAGE_LOCKS_SHARED) |
Number of shared page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Shared Table Locks (TABLE_LOCKS_SHARED) |
Number of shared table locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_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 |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Exclusive Locks (TOTAL_EXCLUSIVE_LOCKS) |
Total number of exclusive locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Extent Locks (EXTENT_LOCKS_TOTAL) |
Total number of extent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Intent Locks (INTENT_LOCKS_TOTAL) |
Total number of intent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_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 |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Page Locks (PAGE_LOCKS_TOTAL) |
Total number of page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Shared Locks (TOTAL_SHARED_LOCKS) |
Total number of shared locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Total Table Locks (TABLE_LOCKS_TOTAL) |
Total number of table locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Update Extent Locks (EXTENT_LOCKS_UPDATE) |
Number of update extent locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Update Page Locks (PAGE_LOCKS_UPDATE) |
Number of update page locks |
-- |
ulong |
No |
master..syslockinfo.rsc_type,master..syslockinfo.req_mode |
sys.dm_tran_locks.resource_type, sys.dm_tran_locks.request_mode |
|
Users Blocked (USERS_BLOCKED) |
Number of users who are blocked by other users |
-- |
ulong |
No |
master..sysprocesses.blocked |
sys.dm_exec_requests.blocking_session_id |
|
VA DeviceID(VADEVICEID) |
Device ID of virtual agent. |
-- |
string(256) |
No |
Remote Monitor Collector |
|