sys-dm-os-cluster-nodes-transact-sql.md

title	sys.dm_os_cluster_nodes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/18/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_os_cluster_nodes_TSQL dm_os_cluster_nodes_TSQL dm_os_cluster_nodes sys.dm_os_cluster_nodes
dev_langs	TSQL
helpviewer_keywords	sys.dm_os_cluster_nodes dynamic management view
ms.assetid	92fa804e-2d08-42c6-a36f-9791544b1d42
caps.latest.revision	36
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

sys.dm_os_cluster_nodes (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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 [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_os_cluster_nodes.

Column name	Data type	Description
NodeName	sysname	Name of a node in the [!INCLUDEssNoVersion] failover cluster instance (virtual server) configuration.
status	int	Status of the node in a [!INCLUDEssNoVersion] failover cluster instance: 0, 1, 2, 3, -1. For more information, see GetClusterNodeState Function.
status_description	nvarchar(20)	Description of the status of the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] failover cluster resource.
pdw_node_id	int	Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW] The identifier for the node that this distribution is on.

Remarks

When failover clustering is enabled, the [!INCLUDEssNoVersion] instance can run on any of the nodes of the failover cluster that are designated as part of the [!INCLUDEssNoVersion] failover cluster instance (virtual server) configuration.

NOTE: This view replaces the fn_virtualservernodes function, which will be deprecated in a future release.

Permissions

Requires VIEW SERVER STATE permission on the instance of [!INCLUDEssNoVersion].

Examples

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;  

[!INCLUDEssResult]

NodeName	status	status_description	is_current_owner
node1	0	up	1
node2	0	up	0
Node3	1	down	0

See Also

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)