SQL Server clustering : Quorum arbitration process

Hi,
Can someone explain in plain english how quorum arbitration process works under MS SQL server?
Please don't paste MSDN links.

Thanks
crazywolf2010Asked:
Who is Participating?
 
Joe KlimisCommented:
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
 
Joe KlimisCommented:
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
 
crazywolf2010Author Commented:
Hi Joe,
I read about  split brain situation. How this is resolved under Sql server 2008? How are resources managed thru Quorum?
0
 
crazywolf2010Author Commented:
Any update on this query please?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.