Events
31 Mar, 23 - 2 Apr, 23
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server Azure Synapse Analytics Analytics Platform System (PDW)
Returns one row for each node in the failover cluster instance configuration. If the current instance is a failover clustered instance, it returns a list of nodes on which this failover cluster instance (formerly "virtual server") has been defined. If the current server instance is not a failover clustered instance, it returns an empty rowset.
Note
To call this from Azure Synapse Analytics or Analytics Platform System (PDW), use the name sys.dm_pdw_nodes_os_cluster_nodes. This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Column name | Data type | Description |
---|---|---|
NodeName | sysname | Name of a node in the SQL Server failover cluster instance (virtual server) configuration. |
status | int | Status of the node in a SQL Server failover cluster instance: 0, 1, 2, 3, -1. For more information, see GetClusterNodeState Function. |
status_description | nvarchar(20) | Description of the status of the SQL Server failover cluster node. 0 = up 1 = down 2 = paused 3 = joining -1 = unknown |
is_current_owner | bit | 1 means this node is the current owner of the SQL Server failover cluster resource. |
pdw_node_id | int | Applies to: Azure Synapse Analytics, Analytics Platform System (PDW) The identifier for the node that this distribution is on. |
When failover clustering is enabled, the SQL Server instance can run on any of the nodes of the failover cluster that are designated as part of the SQL Server failover cluster instance (virtual server) configuration.
Note
This view replaces the fn_virtualservernodes function, which will be deprecated in a future release.
Requires VIEW SERVER STATE permission on the instance of SQL Server.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
The following example uses sys. dm_os_cluster_nodes to return the nodes on a clustered server instance.
SELECT NodeName, status, status_description, is_current_owner
FROM sys.dm_os_cluster_nodes;
Here's the result set.
NodeName | status | status_description | is_current_owner |
---|---|---|---|
node1 | 0 | up | 1 |
node2 | 0 | up | 0 |
Node3 | 1 | down | 0 |
sys.dm_os_cluster_properties (Transact-SQL)
sys.dm_io_cluster_shared_drives (Transact-SQL)
sys.fn_virtualservernodes (Transact-SQL)
Dynamic Management Views and Functions (Transact-SQL)
Events
31 Mar, 23 - 2 Apr, 23
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today