Hi Everyone
Consider the following SQL AlwaysOn configuration in Azure.
3 Nodes in cluster.
Region 1:
Node 1
Node 2
Region 2:
Node 3
Node 3 is asynchronous commit
What is the recommended approach to configuring the quorum here?
Should node 3's vote be removed from the quorum and be replaced with a file share witness?
Versions:
SQL Server 2019
Windows Server 2019
Any advice would be appreciated
Thanks