An organization is designing a high-availability SQL Server Failover Cluster Instance (FCI) hosted on Azure Virtual Machines. The VMs are distributed across Zone 1 and Zone 2 in the East US region.
The storage solution for the FCI database files must meet the following requirements:
- Must be a shared block storage volume that can be attached to all cluster nodes concurrently using SCSI persistent reservations.
- Must survive an availability zone failure with zero data loss (Recovery Point Objective (RPO) = 0).
- Must support sub-millisecond read and write latencies for database transactions.
- Must allow administrative teams to scale storage capacity, IOPS, and throughput independently and dynamically without taking the disks offline or restarting the virtual machines.
Which storage configuration should you recommend?
- Premium SSD v2 configured with Zone-Redundant Storage (ZRS)Cevap
- BUltra Disk configured with Locally Redundant Storage (LRS)
- CPremium SSD configured with Zone-Redundant Storage (ZRS)
- DPremium SSD v2 configured with Locally Redundant Storage (LRS)