Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.dm_exec_compute_node_status (Transact-SQL)
Applies to: 👁 Image
SQL Server 2016 (13.x) and later versions 👁 Image
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)
Feedback
Was this page helpful?