An organization is designing a disaster recovery (DR) solution from the East US region to the West US region for an inventory management system. The system consists of two Web tier VMs (each with a Premium SSD and a write churn of ), two App tier VMs (each with a Premium SSD and a write churn of ), and one Database tier VM running SQL Server on an Azure VM. The Database VM has one OS disk with a write churn of , one data disk with a write churn of , and one transaction log disk with a write churn of . All disks on the Database VM are Premium SSDs. The organization requires a target recovery point objective (RPO) of and a recovery time objective (RTO) of . Which disaster recovery design should you recommend?
- Replicate the Web and App tier VMs using Azure Site Recovery, and configure SQL Server Always On Availability Groups to replicate the database to a SQL Server instance running on an Azure VM in the West US region.Cevap
- BReplicate all virtual machines, including the Database VM, to the West US region using Azure Site Recovery with the high-churn replication profile enabled.
- CReplicate the Web and App tier VMs using Azure Site Recovery, and configure Azure SQL Database auto-failover groups to replicate the database tier VM to the West US region.
- DReplicate the Web and App tier VMs using Azure Site Recovery, and host the database transaction logs on a Read-Access Geo-Redundant Storage (RA-GRS) account to allow active-active database write operations in both regions.
Cevap
Replicate the Web and App tier VMs using Azure Site Recovery, and configure SQL Server Always On Availability Groups to replicate the database to a SQL Server instance running on an Azure VM in the West US region.
The correct design uses Azure Site Recovery to replicate the Web and App tier VMs, while using SQL Server Always On Availability Groups to replicate the database. This is because the Database VM's transaction log disk has a write churn of , which exceeds the maximum support limit of per Premium SSD disk for Azure Site Recovery (even with the high-churn profile enabled). Utilizing SQL Server Always On Availability Groups bypasses this ASR limitation and ensures the database is replicated with minimal latency, satisfying the RPO and RTO.
Adım Adım Çözüm
Anahtar Kavram
Azure Site Recovery (ASR) has strict write churn limits per disk ( standard, high churn for Premium SSD v1) and per VM. For virtual machines running database engines with write-intensive transaction logs that exceed these limits, database-native replication mechanisms (such as SQL Server Always On Availability Groups) must be used instead of ASR.