sys-dm-exec-compute-nodes-transact-sql.md

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.reviewer
ms.technology	system-objects
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
author	stevestein
ms.author	sstein
manager	craigg
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.dm_exec_compute_nodes (Transact-SQL)

[!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

See Also

PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)