How to check whether or not dynamic quorum and dynamic witness is enabled on WSFC?



  • Dynamic quorum and dynamic witness are abilities of the WSFC to dynamically adjust the vote of the nodes and witness to prevent unnecessary failovers.

    Where can I check whether the WSFC configuration is configured such that it performs dynamic quorum and dynamic witness?



  • Where can I check whether the WSFC configuration is configured such that it performs dynamic quorum and dynamic witness?

    If you are using Windows Server 2012 R2 both are enabled by default. You would have to actually setup a WSFC to actually see how it works. Below links can help you in your testing

    https://www.mssqltips.com/sqlservertip/4440/understand-how-dynamic-witness-works-for-a-sql-server-wfsc/

    https://www.mssqltips.com/sqlservertip/4434/dynamic-quorum-for-windows-server-2012-r2-cluster-to-support-sql-server-alwayson/

    Till windows server 2016 you have option on cluster configuration page to Allow cluster to dynamically manage the assignment of node votes option you can enable or disable it. But i would never disable it. Dynamic witness is boon as it does the manual task of toggling the votes in case of node failure to automatic.

    EDIT:

    and there is no choice to disable it

    There is, but actually it is not a choice in form of toggle button. When configuring cluster and configuring witness you see below option enter image description here

    Select do not configure a quorum witness and this feature will not work but remember you are not configuring witness here. I again suggest you to read https://sqlha.com/wsfcs-dynamic-witness-in-windows-server-2012-r2/




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2