Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal
Answers
Where is DBServer2 located? If it is not in de the same region you need to use async commit.
Otherwise delay will cause application issues.
I recommend you read through this article:
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql
The biggest difference with on-prem is:
- Load balancer that is needed in Azure
- All nodes inside your cluster need to be a member of an availability set
- I also recommend using striped volumes for your SQL files to foresee better performance:
https://learn.microsoft.com/en-us/gaming/azure/game-dev-virtual-machine/striped-disks-iops
Feel free to contact me afterwards if you still have questions. I've done it in the past on SQL 2016 and by the looks of it , not too much has changed.