Configure Cluster Quorum NodeWeight Settings
Applies To: SQL Server 2016
This topic describes how to configure NodeWeight settings for a member node in a Windows Server Failover Clustering (WSFC) cluster. NodeWeight settings are used during quorum voting to support disaster recovery and multi-subnet scenarios for Always On Availability Groups and SQL Server Failover Cluster Instances.
This feature is supported only in Windows Server 2008 or later versions.
KB2494036: A hotfix is available to let you configure a cluster node that does not have quorum votes in Windows Server 2008 and in Windows Server 2008 R2
The user must be a domain account that is member of the local Administrators group on each node of the WSFC cluster.
Start an elevated Windows PowerShell via Run as Administrator.
FailoverClustersmodule to enable cluster commandlets.
Get-ClusterNodeobject to set the
NodeWeightproperty for each node in the cluster.
Output the cluster node properties in a readable format.
The following example changes the NodeWeight setting to remove the quorum vote for the “Always OnSrv1” node, and then outputs the settings for all nodes in the cluster.
Import-Module FailoverClusters $node = “Always OnSrv1” (Get-ClusterNode $node).NodeWeight = 0 $cluster = (Get-ClusterNode $node).Cluster $nodes = Get-ClusterNode -Cluster $cluster $nodes | Format-Table -property NodeName, State, NodeWeight
Start an elevated Command Prompt via Run as Administrator.
Use cluster.exe to set
The following example changes the NodeWeight value to remove the quorum vote of the “Always OnSrv1” node in the “Cluster001” cluster.