Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sys.dm_os_cluster_nodes (Transact-SQL)

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.

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. For more information, see GetClusterNodeState Function.

  • 0

  • 1

  • 2

  • 3

  • -1

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.

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 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.

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 is the result set.

NodeName

status

status_description

is_current_owner

node1

0

up

1

node2

0

up

0

Node3

1

down

0

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.