sys.dm_pdw_lock_waits (Transact-SQL)
Applies to: 
Azure Synapse Analytics
Analytics Platform System (PDW)
Holds information about the requests that are waiting for locks.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| wait_id | bigint | Position of the request in the waiting list. | 0-based ordinal. This is not unique across all wait entries. |
| session_id | nvarchar(32) | ID of the session in which the wait state occurred. | See session_id in sys.dm_pdw_exec_sessions (Transact-SQL). |
| type | nvarchar(255) | Type of wait this entry represents. | Possible values: Shared SharedUpdate ExclusiveUpdate Exclusive |
| object_type | nvarchar(255) | Type of object that is affected by the wait. | Possible values: OBJECT DATABASE SYSTEM SCHEMA APPLICATION |
| object_name | nvarchar(386) | Name or GUID of the specified object that was affected by the wait. | Tables and views are displayed with three-part names. Indexes and statistics are displayed with four-part names. Names, principals, and databases are string names. |
| request_id | nvarchar(32) | ID of the request on which the wait state occurred. | ID of the request. This is a GUID for load requests. |
| request_time | datetime | Time at which the lock or resource was requested. | |
| acquire_time | datetime | Time at which the lock or resource was acquired. | |
| state | nvarchar(50) | State of the wait state. | Information not available. |
| priority | int | Priority of the waiting item. | Information not available. |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)