| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_exec_compute_node_status (Transact-SQL) |
sys.dm_exec_compute_node_status (Transact-SQL) |
rwestMSFT |
randolphwest |
11/04/2019 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sqlserver2016-asdbmi]
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. |
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)