Solved

SQL Server clustering : Quorum arbitration process

Posted on 2012-04-02
4
628 Views
Last Modified: 2012-04-26
Hi,
Can someone explain in plain english how quorum arbitration process works under MS SQL server?
Please don't paste MSDN links.

Thanks
0
Comment
Question by:crazywolf2010
  • 2
  • 2
4 Comments
 
LVL 10

Expert Comment

by:JoeKlimis
ID: 37795476
Hi

this is a mechanism to prevent split brain ( bother servers in a failover cluster becoming active at the same time) , when they loose contact with each other..  For the cluster node to be active / "live" then it requires two votes to be promoted to active , or to stay active. one from the host , the other from the quorum disk.

I hope this helps
Joe
0
 

Author Comment

by:crazywolf2010
ID: 37795489
Hi Joe,
I read about  split brain situation. How this is resolved under Sql server 2008? How are resources managed thru Quorum?
0
 

Author Comment

by:crazywolf2010
ID: 37827374
Any update on this query please?
0
 
LVL 10

Accepted Solution

by:
JoeKlimis earned 500 total points
ID: 37831580
Split brain is not resolved by SQL 2008  its a windows feature not a SQL one.

This artical explains how the cluster the quorum workis

http://sqldbpool.com/2010/05/21/split-braintiebreaker-in-cluster/

The quorum uses only a small disk for resource.  You basically set it up in when u create the cluster and requires no management.

I hope this helps

Joe
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql join/ assign small # first 10 83
SQL Update Query - What's wrong with this. 18 20
sql Total query 2 16
Sql Query Datatype 2 18
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now