sys.dm_pdw_node_status (Transact-SQL)

Applies to: Analytics Platform System (PDW)

Holds additional information (over sys.dm_pdw_nodes (Transact-SQL)) about the performance and status of all appliance nodes. It lists one row per node in the appliance.

Column Name	Data Type	Description	Range
pdw_node_id	int	Unique numeric id associated with the node. Key for this view.	Unique across the appliance, regardless of type.
process_id	int	Information not available.
process_name	nvarchar(255)	Information not available.
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 node.
received_time	datetime	Last time a network package was received by this node.
error_id	nvarchar(36)	Unique identifier of the last error that occurred on this node.

See Also

Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)