View Cluster Quorum NodeWeight Settings
Applies to: SQL Server
This topic describes how to view NodeWeight settings for each 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.
Before you start: Prerequisites, Security
To view quorum NodeWeight settings using: Using Transact-SQL, Using Powershell, Using Cluster.exe
Before You Start
Prerequisites
This feature is supported only in Windows Server 2008 or later versions.
Important
In order to use NodeWeight settings, the following hotfix must be applied to all servers in the WSFC cluster:
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
Tip
If this hotfix is not installed, the examples in this topic will return empty or NULL values for NodeWeight.
Security
The user must be a domain account that is member of the local Administrators group on each node of the WSFC cluster.
Using Transact-SQL
To view NodeWeight settings
Connect to any SQL Server instance in the cluster.
Query the [sys].[dm_hadr_cluster_members] view.
Example (Transact-SQL)
The following example queries a system view to return values for all of the nodes in that instance's cluster.
SELECT member_name, member_state_desc, number_of_quorum_votes
FROM sys.dm_hadr_cluster_members;
Using Powershell
To view NodeWeight settings
Start an elevated Windows PowerShell via Run as Administrator.
Import the
FailoverClusters
module to enable cluster commandlets.Use the
Get-ClusterNode
object to return a collection of cluster node objects.Output the cluster node properties in a readable format.
Example (Powershell)
The following example output some of the node properties for the cluster called "Cluster001".
Import-Module FailoverClusters
$cluster = "Cluster001"
$nodes = Get-ClusterNode -Cluster $cluster
$nodes | Format-Table -property NodeName, State, NodeWeight
Using Cluster.exe
Note
The cluster.exe utility is deprecated in the Windows Server 2008 R2 release. Please use PowerShell with Failover Clustering for future development. The cluster.exe utility will be removed in the next release of Windows Server. For more information, see Mapping Cluster.exe Commands to Windows PowerShell Cmdlets for Failover Clusters.
To view NodeWeight settings
Start an elevated Command Prompt via Run as Administrator.
Use cluster.exe to return node status and NodeWeight values
Example (Cluster.exe)
The following example outputs some of the node properties for the cluster called "Cluster001".
cluster.exe Cluster001 node /status /properties
See Also
WSFC Quorum Modes and Voting Configuration (SQL Server)
Configure Cluster Quorum NodeWeight Settings
sys.dm_hadr_cluster_members (Transact-SQL)
Failover Cluster Cmdlets in Windows PowerShell Listed by Task Focus