Locks
(SPID, LOCKID, LOCKTYPE)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| LOGIN | string(32) | Login name |
| BLOCKINGSPID | long | Blocker session process ID (SPID), if applicable |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| DBNAME | string(32) | Database name |
| PARENTSPID | long | Session process ID (SPID) of the parent process, if this is a worker process |
| LOCKID | long | Lock ID |
| TABNAME | string(256) | Name of the locked object |
| LOCKSTATE | string(24) | Lock state (Granted, Requested) |
| LOCKTYPE | string(32) | Lock type:
|
| LOCKLEVEL | string(32) | Lock level (ROW, PAGE, TABLE, ADDRESS) |
| WAITTIME | long | Duration of time waiting on the lock, in seconds |
| PAGE | string(20) | Page # that is locked if LockType = PAGE |
| ROW | string(20) | Row # that is locked if LockType = ROW |
| PARTITIONID | long | Partition ID |
| OBJECTID | long | Object ID |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |