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)
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