THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tamarick Hill

July, the 31 Days of SQL Server DMO’s – Day 14 (sys.dm_os_cluster_nodes)


The sys.dm_os_cluster_nodes DMV has been around since the 2005 version of SQL Server, but its result set was very limited up until 2012. In SQL Server 2005, 2008 and 2008R2, the DMV simply returns the Node Names for all of the servers that are part of a cluster. This one column in the only thing returned.

In SQL Server 2012, the DMV has been expanded to include status and status_description columns, which tells us whether a particular node is “up”, “down”, “paused”, “joining”, or “unknown”. In addition, the 2012 version of this DMV also includes an ‘is_current_owner’ column to indicate which node is the current owner of the SQL Server cluster resource.

This is a very simplistic DMV but returns useful information about the nodes making up your cluster and their current status.

For more information about this DMV, please see the below Books Online link:

Follow me on Twitter @PrimeTimeDBA

Published Sunday, July 14, 2013 10:53 AM by Tamarick Hill


No Comments
New Comments to this post are disabled
Privacy Statement