Always On HA+DR

Question

Hi Experts,

I was trying to setup a alwayson between onpremise datacenter and azure(1 node in datacenter and 1 in azure) with an average latency of 125 MS.
Any feedback if anyone has done a similar setup and if any issues to it.

Thanks

Answer 1

Apologies for the delay in response. I might need additional information to help you out on your issue.

Is your question about SQL Server on Azure VM, and if so, can you please share details on what networking and other IaaS components are part of the solution?
If this is Azure SQL Database (PaaS), are you using Data Replication or Data Sync?

Azure SQL Database (PaaS) Always On Availability Groups does not support 'Always On' with an On-Premise instance.
However, 'SQL Server on a VM' support Active Directory domain-independent clusters.

Please refer to:
Configure a workgroup availability group where IaaS can better support the on-premise networking aspect.
Tutorial: Configure a SQL Server availability group on Azure Virtual Machines manually

Azure SQL Database (PaaS) 'Always On' Availability Groups is primarily supported by Azure Paired Regions and the high bandwidth networking between these paired regions to fail-over sets of databases at a time.

Here is a reference document for Azure PaaS Database services: High availability for Azure SQL Database and SQL Managed Instance.