SOLVED

Windows Server Failover Cluster Disk Witness Setup

%3CLINGO-SUB%20id%3D%22lingo-sub-2278485%22%20slang%3D%22en-US%22%3EWindows%20Server%20Failover%20Cluster%20Disk%20Witness%20Setup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278485%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20Windows%202012%20R2%20failover%20cluster%20running%20a%20MSSQL%202014%20cluster%20resource.%20It's%20a%202-node%20cluster%20with%20a%20disk%20%5BQ%3A%5D%20witness%20presented%20to%20the%20cluster%20from%20our%20SAN%20over%20fibre-channel.%20One%20thing%20I%20notice%20though%20is%20that%20this%20disk%20witness%20Q%3A%20is%20also%20a%20storage%20resource%20under%20the%20MSSQL%20cluster%20resource.%20Surely%20that's%20an%26nbsp%3B%3C%2FSPAN%3E%3CEM%3E%3CSTRONG%3Eincorrect%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FEM%3E%3CSPAN%3Econfiguration%3F%20My%20understanding%20is%20the%20disk%20witness%20should%20only%20be%20part%20of%20the%20core%20cluster%20resource%20and%20not%20assigned%20as%20storage%20to%20any%20sub%20resource%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EClustering%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2278846%22%20slang%3D%22en-US%22%3ERe%3A%20Windows%20Server%20Failover%20Cluster%20Disk%20Witness%20Setup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278846%22%20slang%3D%22en-US%22%3E%3CP%3EWindows%20Server%20Failover%20Clustering%20(WSFC)%20is%20the%20features%20for%20providing%20high%20availability%20for%20SQL%20Server%20workloads%20-%20for%20both%20failover%20clustered%20instances%20and%20also%20Availablity%20Groups%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20the%20quorum%20configuration%20option%20that%20you%20choose%20and%20your%20specific%20settings%2C%20the%20cluster%20will%20be%20configured%20in%20one%20of%20the%20following%20quorum%20modes%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENode%20majority%20(no%20witness)%3C%2FSTRONG%3E%20-%20Only%20nodes%20have%20votes.%20No%20quorum%20witness%20is%20configured.%3CBR%20%2F%3E%3CSTRONG%3ENode%20majority%20with%20witness%20(disk%20or%20file%20share%3C%2FSTRONG%3E)%20-%20Nodes%20have%20votes.%20In%20addition%2C%20a%20quorum%20witness%20has%20a%20vote.%20The%20cluster%20quorum%20is%20the%20majority%20of%20voting%20nodes%20in%20the%20active%20cluster%20membership%20plus%20a%20witness%20vote.%20A%20quorum%20witness%20can%20be%20a%20designated%20disk%20witness%20or%20a%20designated%20file%20share%20witness.%3CBR%20%2F%3E%3CSTRONG%3ENo%20majority%20(disk%20witness%20only)%3C%2FSTRONG%3E%20-%20No%20nodes%20have%20votes.%20Only%20a%20disk%20witness%20has%20a%20vote.%3CBR%20%2F%3EThe%20cluster%20quorum%20is%20determined%20by%20the%20state%20of%20the%20disk%20witness.%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3C%2FSTRONG%3E%3A%20A%20Disk%20Witness%20isn't%20supported%20with%20Storage%20Spaces%20Direct.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3E%3CSTRONG%3EDisk%20witness%3C%2FSTRONG%3E%3CBR%20%2F%3EDedicated%20LUN%20that%20stores%20a%20copy%20of%20the%20cluster%20database%3CBR%20%2F%3EMost%20useful%20for%20clusters%20with%20shared%20(not%20replicated)%20storage%3C%2FLI%3E%3CLI%3E%3CSTRONG%3EFile%20share%20witness%3C%2FSTRONG%3E%3CBR%20%2F%3ESMB%20file%20share%20that%20is%20configured%20on%20a%20file%20server%20running%20Windows%20Server%3CBR%20%2F%3EDoes%20not%20store%20a%20copy%20of%20the%20cluster%20database%3C%2FLI%3E%3CLI%3E%3CSTRONG%3ECloud%20witness%3C%2FSTRONG%3E%3CBR%20%2F%3EA%20witness%20file%20stored%20in%20Azure%20Blob%20Storage%3CBR%20%2F%3ERecommended%20when%20all%20servers%20in%20the%20cluster%20have%20a%20reliable%20Internet%20connection.%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Contributor

I have a Windows 2012 R2 failover cluster running a MSSQL 2014 cluster resource. It's a 2-node cluster with a disk [Q:] witness presented to the cluster from our SAN over fibre-channel. One thing I notice though is that this disk witness Q: is also a storage resource under the MSSQL cluster resource. Surely that's an incorrect configuration? My understanding is the disk witness should only be part of the core cluster resource and not assigned as storage to any sub resource?

1 Reply
best response confirmed by shocko (Contributor)
Solution

Windows Server Failover Clustering (WSFC) is the features for providing high availability for SQL Server workloads - for both failover clustered instances and also Availablity Groups

 

Depending on the quorum configuration option that you choose and your specific settings, the cluster will be configured in one of the following quorum modes:

 

Node majority (no witness) - Only nodes have votes. No quorum witness is configured.
Node majority with witness (disk or file share) - Nodes have votes. In addition, a quorum witness has a vote. The cluster quorum is the majority of voting nodes in the active cluster membership plus a witness vote. A quorum witness can be a designated disk witness or a designated file share witness.
No majority (disk witness only) - No nodes have votes. Only a disk witness has a vote.
The cluster quorum is determined by the state of the disk witness.

Note: A Disk Witness isn't supported with Storage Spaces Direct.

 

  1. Disk witness
    Dedicated LUN that stores a copy of the cluster database
    Most useful for clusters with shared (not replicated) storage
  2. File share witness
    SMB file share that is configured on a file server running Windows Server
    Does not store a copy of the cluster database
  3. Cloud witness
    A witness file stored in Azure Blob Storage
    Recommended when all servers in the cluster have a reliable Internet connection.