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)