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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho