Soru

Zorluk: OrtaDesign Azure Site Recovery Solutions

A financial services company hosts a transactional SQL Server database on an Azure virtual machine (VM) in the East US region. You are designing a disaster recovery (DR) solution to the West US region. The solution must meet a Recovery Time Objective (RTO) of 2 hours2\text{ hours} and a Recovery Point Objective (RPO) of 10 minutes10\text{ minutes}.

The database VM has the following storage configuration:
- One 128 GB128\text{ GB} OS disk
- One 512 GB512\text{ GB} Premium SSD disk for transaction logs, with a peak write churn of 65 MB/s65\text{ MB/s}
- Two 1 TB1\text{ TB} Premium SSD disks for database files, with a combined peak write churn of 40 MB/s40\text{ MB/s}

Which disaster recovery solution should you recommend?

  1. Configure SQL Server Always On Availability Groups to replicate the database to a target virtual machine in the West US region.Cevap
  2. B
    Enable Azure Site Recovery (ASR) replication for the virtual machine and configure the High Churn replication policy.
  3. C
    Configure Azure Backup with Cross-Region Restore (CRR) to replicate the virtual machine's daily backups to the West US region.
  4. D
    Enable Azure Site Recovery (ASR) replication for the virtual machine and deploy an on-premises configuration server to manage replication.

Cevap

Configure SQL Server Always On Availability Groups to replicate the database to a target virtual machine in the West US region.
The transaction log disk has a peak write churn of 65 MB/s65\text{ MB/s}, and the total peak write churn of the virtual machine is 105 MB/s105\text{ MB/s}. Azure Site Recovery (ASR) has a maximum supported write churn limit of 54 MB/s54\text{ MB/s} per disk and 100 MB/s100\text{ MB/s} per virtual machine, even when using the High Churn policy. Since these limits are exceeded, ASR cannot be used. Implementing database-level replication such as SQL Server Always On Availability Groups is the correct design pattern because it operates at the database engine layer and is not bound by ASR's disk-level write churn replication limits.

Adım Adım Çözüm

1
Evaluate the write churn metrics of the workload against Azure Site Recovery limits.
The log disk churn (65 MB/s65\text{ MB/s}) exceeds the 54 MB/s54\text{ MB/s} High Churn limit, and the total VM churn (105 MB/s105\text{ MB/s}) exceeds the 100 MB/s100\text{ MB/s} limit.
Determines whether Azure Site Recovery is a viable technology for replicating this virtual machine.
2
Evaluate the backup solution against the RPO requirement.
Azure Backup cannot meet a 10-minute10\text{-minute} RPO as it operates on scheduled snapshots.
Rules out backup-based replication for low-RPO transactional requirements.
3
Select a database-native replication strategy that bypasses infrastructure-level disk churn limits.
SQL Server Always On Availability Groups replicates transactions at the database tier and is not subject to Azure Site Recovery's block-level replication limits.
Provides a compliant disaster recovery solution that meets the RPO, RTO, and workload limits.

Anahtar Kavram

Azure Site Recovery write churn limits and database-level replication alternatives
Tahmini Süre:1m 30s
Bu soruyu puanla