THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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:

http://msdn.microsoft.com/en-us/library/ms187341(v=sql.110).aspx

Follow me on Twitter @PrimeTimeDBA

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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement