Solved

SQL Server clustering : Quorum arbitration process

Posted on 2012-04-02
4
634 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Writing SQL Select Query result to a text file 12 56
SQL Server 2012 r2 - Make Temp Table Query Faster 5 50
union query column need default text 2 15
SQL trigger 5 19
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 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