If the WSFC node that hosts a local instance of SQL Server that is enabled for AlwaysOn Availability Groups has WSFC quorum, returns a row for each of the members that constitute the quorum and the state of each of them. This includes of all nodes in the cluster (returned with CLUSTER_ENUM_NODE type by the Clusterenum function) and the disk or file-share witness, if any. The row returned for a given member contains information about the state of that member. For example, for a five node cluster with majority node quorum in which one node is down, when sys.dm_hadr_cluster_members is queried from a server instance that is that is enabled for AlwaysOn Availability Groups that resides on a node with quorum, sys.dm_hadr_cluster_members reflects the state of the down node as "NODE_DOWN".
If the WSFC node has no quorum, no rows are returned.
Use this dynamic management view to answer the following questions:
What nodes are currently running on the WSFC cluster?
How many more failures can the WSFC cluster tolerate before losing quorum in a majority-node case?
Member name, which can be a computer name, a drive letter, or a file share path.
The type of member, one of:
0 = WSFC node
1 = Disk witness
2 = File share witness
Description of member_type, one of:
The member state, one of:
0 = Offline
1 = Online
Description of member_state, one of:
Number of quorum votes possessed by this quorum member. For No Majority: Disk Only quorums, this value defaults to 0. For other quorum types, this value defaults to 1.