SQL Server: Setting up Quorum Node Weight in a Windows Server Failover Cluster

I had a request coming in where I was asked to demo the capabilities of AlwaysOn feature using Availability Groups in SQL Server 2012 (a note on what is availability group deserves an explanation and a separate blog post, till that time you can read an introductory post which I had written here)

I will assume that you have configured a WSFC (Windows Server Failover Cluster). At time of writing this blog, I had a two node failover cluster at same site (single site) which I had created using Windows Server 2008 R2 and the quorum model used was Node + Disk. To get know more about Quorum you can check this wonderful article at MSDN here. Note that you will be required to apply this hotfix to configure a cluster node that does not have quorum votes.

Now using powershell you can not only view but also administer the failover cluster and its resources. I will be using powershell v3.0. Setting up a node weight is very easy and in a matter of few lines of code you can get the cluster and the quorum model up and running.

$cluster=Get-Cluster

$node=Get-ClusterNode-Cluster $cluster
(Get-ClusterNode-Cluster $cluster -Name‘Node name goes here’).NodeWeight=1

No marks for guessing here, but if you have been using v2.0 of powershell, and wondering that why I have not imported the “FailoverClusters”module in this sessions, the answer is all necessary modules are imported at run time required for any cmdlets. This is a new feature introduced in the v3.0 of powershell.

You can repeat this script in all the nodes which you desire to have voting rights in your single site or multi-site setup just by changing the name of the respective node in the cluster.

In order to verify the change that this script has made, I executed a DMV in the SQL Server Management Studio and verified the values in the column number_of_quorum_votes

use master
select*from sys.dm_hadr_cluster_members

 

 
Regards

Raunak Jhawar

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook

 
Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *