sys.dm_pdw_wait_stats (Transact-SQL)

Applies to: yesAzure Synapse Analytics yesParallel Data Warehouse

Holds information related to the SQL Server OS state related to instances running on the different nodes. For a list of waits types and their description, see sys.dm_os_wait_stats.

Column Name Data Type Description Range
pdw_node_id int ID of the node this entry refers to.
wait_name nvarchar(255) Name of the wait type.
max_wait_time bigint Maximum wait time of this wait type.
request_count bigint Number of waits of this wait type outstanding.
signal_time bigint Difference between the time that the waiting thread was signaled and when it started running.
completed_count bigint Total number of waits of this type completed since the last server restart.
wait_time bigint Total wait time for this wait type in millisecons. Inclusive of signal_time.

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
sys.dm_pdw_waits (Transact-SQL)