sys.dm_exec_compute_nodes (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions

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

See Also