Configure Cluster Quorum Node Weight Settings
3674
post-template-default,single,single-post,postid-3674,single-format-standard,cookies-not-set,ajax_fade,page_not_loaded,,side_area_uncovered_from_content,qode-theme-ver-15.0,qode-theme-bridge,wpb-js-composer js-comp-ver-5.4.7,vc_responsive
 

Configure Cluster Quorum Node Weight Settings

Configure Cluster Quorum Node Weight Settings

While using SQL AlwaysOn in connection with a third node on a different location as a DR solution, the third node is needed only in case there is a real Disaster Recovery. For this purpose in most cases a manual intervention/failover is needed and you need to align your DR Cluster Node Weight for it. You can use following PowerShell snippet:


Import-Module FailoverClusters

$node = 'AlwaysOnNode1'
(Get-ClusterNode $node).NodeWeight = 0

$cluster = (Get-ClusterNode $node).Cluster
$nodes = Get-ClusterNode -Cluster $cluster

$nodes | Format-Table -property NodeName, State, NodeWeight

No Comments

Sorry, the comment form is closed at this time.

%d bloggers like this: