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
PolyBase troubleshooting with dynamic management views
Dynamic Management Views and Functions (Transact-SQL)
Database Related Dynamic Management Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för