Sample Header Ad - 728x90

Configuring SQL Server 2019 Always ON between 2 Azure reqions

0 votes
1 answer
403 views
I have SQL Server on Azure VM which I want to replicate across a separate region. I will only be using 2 servers, each in a separate region. I have the following questions as I need to clear all doubts about this implementation 1. Since they are in separate region, i found in microsoft docs and several online document that an asynchronous commit is recommended, what if i try to use a synchronous commit so that i can implement automatic failover? Are there any possible issues with synchronous commit considering my scenario 2. I also know that to avoid split brain issues I will need to configure Azure cluster Cloud witness to achieve the odd quorum votes. Considering my scenario of just 2 servers in different region, which region is better to configure this cloud witness. 3. Since I am using SQL Server Azure VM will I need a load balancer and consdering the information on this site https://www.sqlservercentral.com/articles/configuring-sql-server-always-on-azure-serversiaas Do I really need a load balancer? Thanks for your assistance I have read Microsoft documents to see the requirements for I have further questions
Asked by dennis (1 rep)
Oct 24, 2023, 05:41 PM
Last activity: Mar 6, 2025, 06:08 AM