CLusterQuorum Type result

Question

Hi all,
I have setup SQL server 2016 (OS Windows server 2016) always on , my availability group has 2 node and 1 file share witness , this is SQL query result :
SELECT cluster_name, quorum_type_desc, quorum_state_desc
FROM sys.dm_hadr_cluster;

DB-ETMS-WSFC NODE_AND_FILE_SHARE_MAJORITY NORMAL_QUORUM

This is my powershell result :
Get-ClusterQuorum | fl

Cluster        : DB-ETMS-WSFC
QuorumResource : File Share Witness
QuorumType     : Majority

This result make me confused , "QuorumType" should be "NodeMajority" or "NodeAndFileShareMajority" (in my case) ?

Answer 1

Hi,
Node Majority is recommended for clusters with an odd number of nodes (3-nodes, 5-nodes, etc.).
Node & File Share Majority is usually used in multi-site clusters. This configuration is used when there is an even number of nodes in the cluster. In this configuration every node gets 1 vote, and additionally 1 remote file share gets 1 vote.
(https://techcommunity.microsoft.com/t5/failover-clustering/understanding-quorum-in-a-failover-cluster/ba-p/371678)

According to your description, you have two nodes and a file share witness. You can check the “Witness” in failover cluster management, if it is “File Share Witness", your cluster quorum type is Node & File Share Majority.

You can also read the following article to help check/verify Your Cluster Quorum Settings:
https://www.altaro.com/hyper-v/file-share-witness-hyper-v-cluster/

Thanks for your time!
Best Regards,
Mico Mi

-----------------------------

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html

Answer 2

Hi, I have checked the “Witness” in failover cluster management , cluster quorum type is Node & File Share Majority , I just confused about powershell result "QuorumType"