TechNet
Export (0) Print
Expand All

sys.dm_hadr_cluster (Transact-SQL)

 

Applies To: SQL Server

If the Windows Server Failover Clustering (WSFC) node that hosts an instance of SQL Server that is enabled for Always On Availability Groups has WSFC quorum, sys.dm_hadr_cluster returns a row that exposes the cluster name and information about the quorum. If the WSFC node has no quorum, no row is returned.

Applies to: SQL Server (SQL Server 2012 through current version).
System_CAPS_ICON_tip.jpg Tip


Beginning in SQL Server 2014, this dynamic management view supports Always On Failover Cluster Instances in addition to Always On Availability Groups.

Column nameData typeDescription
cluster_namenvarchar(128)Name of the WSFC cluster that hosts the instances of SQL Server that are enabled for Always On Availability Groups.
quorum_typetinyintType of quorum used by this WSFC cluster, one of:

0 = Node Majority. This quorum configuration can sustain failures of half the nodes (rounding up) minus one. For example, on a seven node cluster, this quorum configuration can sustain three node failures.

1 = Node and Disk Majority. If the disk witness remains on line, this quorum configuration can sustain failures of half the nodes (rounding up). For example, a six node cluster in which the disk witness is online could sustain three node failures. If the disk witness goes offline or fails, this quorum configuration can sustain failures of half the nodes (rounding up) minus one. For example, a six node cluster with a failed disk witness could sustain two (3-1=2) node failures.

2 = Node and File Share Majority. This quorum configuration works in a similar way to Node and Disk Majority, but uses a file-share witness instead of a disk witness.

3 = No Majority: Disk Only. If the quorum disk is online, this quorum configuration can sustain failures of all nodes except one.
quorum_type_descvarchar(50)Description of quorum_type, one of:

NODE_MAJORITY

NODE_AND_DISK_MAJORITY

NODE_AND_FILE_SHARE_MAJORITY

NO_MAJORITY:_DISK_ONLY
quorum_statetinyintState of the WSFC quorum, one of:

0 = Unknown quorum state

1 = Normal quorum

2 = Forced quorum
quorum_state_descvarchar(50)Description of quorum_state, one of:

UNKNOWN_QUORUM_STATE

NORMAL_QUORUM

FORCED_QUORUM

Requires VIEW SERVER STATE permission on the server.

Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Dynamic%20Management%20Views%20and%20Functions%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"13ce70e4-9d43-4a80-a826-099e6213bf85","entity_type":"Article","locale":"en-US"}'.
Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Catalog%20Views%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"13ce70e4-9d43-4a80-a826-099e6213bf85","entity_type":"Article","locale":"en-US"}'.
Monitor Availability Groups (Transact-SQL)
sys.dm_hadr_cluster_members (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft