| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_exec_compute_nodes (Transact-SQL) |
sys.dm_exec_compute_nodes (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sqlserver2016]
Holds information about nodes used with PolyBase data management. It lists one row per node.
Use this DMV to see the list of all nodes in the scale-out cluster with their role, name and IP address.
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| compute_node_id | int | Unique numeric id associated with the node. Key for this view. | Unique across scale-out cluster regardless of type. |
| type | nvarchar(32) | Type of the node. | 'COMPUTE', 'HEAD' |
| name | nvarchar(32) | Logical name of the node. | Any string of appropriate length. |
| address | nvarchar(32) | IP address of this node. | IP address range |
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)