sys.dm_exec_compute_node_status (Transact-SQL)

APPLIES TO: YesSQL Server 2016 and later NoAzure SQL Database YesAzure Synapse Analytics (SQL DW) YesParallel Data Warehouse

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)