Quorum Considerations for SQL Server 2012


Quorum is managed by the WSFC, irrespective of the number of SQL Server instances (FCI or standalone), number of nodes, number of availability groups

  • Important goal: Design to ensure

Unavailability of the DR site, or loss of network connectivity between sites should not impact the quorum of the WSFC

  • Two steps:

Node votes: First decide which nodes should have a vote

Quorum Model: Then choose the appropriate quorum model

  • Node Votes

By default, every node has a vote => May not be ideal for your specific HA / DR goals

Windows Server hotfix: http://support.microsoft.com/kb/2494036

Guidelines: http://msdn.microsoft.com/en-us/library/hh270280.aspx#RecommendedAdjustmentstoQuorumVoting

Odd number of votes

Advertisements
This entry was posted in SQL SERVER 2012 and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s