question

bsantosh6 avatar image
bsantosh6 asked

AG quorum- how is it affected when nodes are removed from AG but continue to be part of windows cluster?

I have a 4 node cluster (2 synch,2 asynch,Fileshare witness). Due to performance issues I have removed the 2 asynch nodes from AG. I have let them be a part of the windows cluster though. Now, how will this affect my AG quorum? Will the 2 async nodes continue to vote even though they arent part of the AG ? Or it only the FSW , the 2 synch nodes that vote for AG quorum ?

sql server 2016
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Why does the AG dashboard show that the 2 synch nodes have votes even though they arent part of AG anymore? They re only part of the windows cluster.

Should my actual vote only be FSW + Synch node1 + synch node 2?


Also, at what point will my AG lose quorum considering that only 2 of my 4 nodes are actually part of AG?

0 Likes 0 ·
image.jpg (68.6 KiB)

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

Quorum is a cluster setting not an AG setting, so the basic premise still ensues, so with that 5 node vote, lose 2 your ok, lose 3 your down.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.