sys.dm_pdw_waits (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Holds information about all wait states encountered during execution of a request or query, including locks, waits on transmission queues, and so on.


This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Column Name Data Type Description Range
wait_id bigint Unique numeric id associated with the wait state.

Key for this view.
Unique across all waits in the system.
session_id nvarchar(32) ID of the session on 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. Information not available.
object_type nvarchar(255) Type of object that is affected by the wait. Information not available.
object_name nvarchar(386) Name or GUID of the specified object that was affected by the wait.
request_id nvarchar(32) ID of the request on which the wait state occurred. See request_id in sys.dm_pdw_exec_requests (Transact-SQL).
request_time datetime Time at which the wait state 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)
sys.dm_pdw_wait_stats (Transact-SQL)