Locks
Comments
Only the first 10,000 locks per session ID are selected, and overall, only the first 30,000 rows are returned.
Columns
| Name |
Description |
| Database |
Database name |
| Object |
Object name |
| IndexID |
Index ID |
| Lock Type |
Resource type, including (but not limited to):
- APP
- Application
- AU
- Allocation Unit
- DB
- Database
- EXT
- Extent
- FIL
- File
- HBT
- HOBT
- KEY
- Key (i.e. unique index)
- MD
- Metadata
- PAG
- Page
- RID
- Row ID
- TAB
- Table
|
| Resource |
Description of lock resource; for RID type, this is %%lockres%% on the table row |
| Mode |
Lock request mode, including (not not limited to):
- BU
- Bulk operation
- IS
- Intent Shared
- IU
- Intent Update
- IX
- Intent Exclusive
- RangeIn-Null
- Insert Key-Range + Null
- RangeIn-S
- Key-Range Conversion, RangeIn-Null + S
- RangeIn-U
- Key-Range Conversion, RangeIn-Null + U
- RangeIn-X
- Key-Range Conversion, RangeIn-Null + X
- RangeS-S
- Shared Key-Range + Shared
- RangeS-U
- Shared Key-Range + Update
- RangeX-S
- Key-Range Conversion, RangeIn-Null + RangeS-S
- RangeX-U
- Key-Range Conversion, RangeIn-Null + RangeS-U
- RangeX-X
- Exclusive Key-Range + Exclusive
- S
- Shared
- Sch-M
- Schema modification
- Sch-S
- Schema stability
- SIU
- Shared Intent Update
- SIX
- Shared Intent Exclusive
- U
- Update
- UIX
- Update Intent Exclusive
- X
- Exclusive
|
| Status |
Request status, including (but not limited to):
- CNVT
- Converting (waiting)
- GRANT
- Granted
- WAIT
- Waiting
|
| SPID |
Session ID |
| User Name |
Login name |
Entity Requirements
| Attributes: |
None |
| Minimum database version: |
9.0 |