sys.dm_exec_compute_node_status (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Managed Instance
Holds additional information about the performance and status of all PolyBase nodes. Lists one row per node.
Column Name | Data Type | Description | Range |
---|---|---|---|
compute_node_id | int |
Unique numeric id associated with the node. | Unique across scale-out cluster regardless of type. |
process_id | int |
||
process_name | nvarchar(255) |
Logical name of the node. | Any string of appropriate length. |
allocated_memory | bigint |
Total allocated memory on this node. | |
available_memory | bigint |
Total available memory on this node. | |
process_cpu_usage | bigint |
Total process CPU usage, in ticks. | |
total_cpu_usage | bigint |
Total CPU usage, in ticks. | |
thread_count | bigint |
Total number of threads in use on this node. | |
handle_count | bigint |
Total number of handles in use on this node. | |
total_elapsed_time | bigint |
Total time elapsed since system start or restart. | Total time elapsed since system start or restart. If total_elapsed_time exceeds the maximum value for an integer (24.8 days in milliseconds), it will cause materialization failure due to overflow.The maximum value in milliseconds is equivalent to 24.8 days. |
is_available | bit |
Flag indicating whether this node is available. | |
sent_time | datetime |
Last time a network package was sent by this | |
received_time | datetime |
Last time a network package was sent by this node. | |
error_id | nvarchar(36) |
Unique identifier of the last error that occurred on this node. | |
compute_pool_id | int |
Unique identifier for the pool. |
See Also
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (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