SQL: Always On Availability Group - Failover Cluster Info
Author: jason
Date: 2014-05-08 14:15:17
Category: Technical

Here is small script to review a couple Windows Failover Cluster settings from inside SQL 2012.

Monitor Availability Groups: http://technet.microsoft.com/en-us/library/ff878305.aspx





Code

--Failover Cluster Info
SELECT cluster_name, REPLACE(quorum_type_desc, '_', ' ') [quorum_type_desc]
, REPLACE(quorum_state_desc, '_', ' ') [quorum_state_desc]
FROM sys.dm_hadr_cluster








jason @ jasonthomasfrance.com - www.masterstationlog.com - copyright 2009