Skip to content

view-cluster-quorum-nodeweight-settings.md

Latest commit

 

History

History
102 lines (71 loc) · 4.8 KB

view-cluster-quorum-nodeweight-settings.md

File metadata and controls

102 lines (71 loc) · 4.8 KB
title View Cluster Quorum NodeWeight Settings | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology high-availability
ms.topic conceptual
helpviewer_keywords
Availability Groups [SQL Server], WSFC clusters
quorum [SQL Server], AlwaysOn and WSFC quorum
ms.assetid b845e73a-bb01-4de2-aac2-8ac12abebc95
author MashaMSFT
ms.author mathoma
manager craigg

View Cluster Quorum NodeWeight Settings

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 [!INCLUDEssHADR] and [!INCLUDEssNoVersion] Failover Cluster Instances.

Before You Start

Prerequisites

This feature is supported only in [!INCLUDEfirstref_longhorn] 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 [!INCLUDEfirstref_longhorn] and in [!INCLUDEwinserver2008r2]

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

  1. Connect to any [!INCLUDEssNoVersion] instance in the cluster.

  2. 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

  1. Start an elevated Windows PowerShell via Run as Administrator.

  2. Import the FailoverClusters module to enable cluster commandlets.

  3. Use the Get-ClusterNode object to return a collection of cluster node objects.

  4. 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 [!INCLUDEwinserver2008r2] 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

  1. Start an elevated Command Prompt via Run as Administrator.

  2. 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