title: "sys.dm_exec_compute_nodes (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-data-warehouse, pdw" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "DM_EXEC_COMPUTE_NODES_TSQL"
- "DM_EXEC_COMPUTE_NODES"
- "SYS.DM_EXEC_COMPUTE_NODES_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.dm_exec_compute_nodes management view"
- "PolyBase, views"
- "PolyBase management views"
- "dm_exec_compute_nodes management view" ms.assetid: 0de4b7a4-401f-4e2d-9ab0-c54587e05154 caps.latest.revision: 8 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-pdw-md]
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) | P 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)