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