sys.dm_pdw_wait_stats (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) 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)