Applies to: Azure Synapse Analytics Analytics Platform System (PDW)
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.
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
|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.|