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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें