May 8, 2017 at 12:36 am
I want to know what is the purpose of File server as a part of SQL cluster resource .
I have quorum disk , is File server still required ? Is it required for voting purposes ? I hope its not a split brain scenario
Our setup is a 2 node cluster and node weight looks 1 for both nodes which seems to be fine to me .
May 8, 2017 at 11:23 am
muzikfreakster - Monday, May 8, 2017 12:36 AMI want to know what is the purpose of File server as a part of SQL cluster resource .
I have quorum disk , is File server still required ? Is it required for voting purposes ? I hope its not a split brain scenario
Our setup is a 2 node cluster and node weight looks 1 for both nodes which seems to be fine to me .
in a 2 node cluster which spans multiple sites you should use a fileshare witness, this share will sit on a machine not specifically a fileserver, but a machine thats accessible from both nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
May 8, 2017 at 9:15 pm
that doesn't answer my question . I want to know the use of file server when I have a quorum already ?
also when I run
SELECT member_name, member_state_desc, number_of_quorum_votes
FROM sys.dm_hadr_cluster_members;
It doesn't return any value
May 11, 2017 at 7:49 am
muzikfreakster - Monday, May 8, 2017 9:15 PMthat doesn't answer my question . I want to know the use of file server when I have a quorum already ?also when I run
SELECT member_name, member_state_desc, number_of_quorum_votes
FROM sys.dm_hadr_cluster_members;
It doesn't return any value
you gain quorum by configuring an odd number of votes in the cluster. If you do this then add a fileshare witness its a futile exercise as the cluster service will then go remove a vote from somewhere else
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy