sys.dm_pdw_wait_stats (Transact-SQL)
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.
Note
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. |
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
sys.dm_pdw_waits (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru