sys.dm_exec_compute_nodes (Transact-SQL)

APPLIES TO: YesSQL Server 2016 and later NoAzure SQL Database YesAzure Synapse Analytics (SQL DW) YesParallel Data Warehouse

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

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