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)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για