You need to migrate existing databases from Microsoft SQL Server 2016 Standard Edition on a single Windows Server 2019 Datacenter Edition to a single Cloud SQL for SQL Server instance. During the…

Question

Options

• ACreate a SQL Server 2019 Standard on Standard machine type with 4 vCPUs, 15 GB of RAM,
• BCreate a SQL Server 2019 Standard on High Memory machine type with at least 16 vCPUs, 104
• CCreate a SQL Server 2019 Standard on High Memory machine type with 16 vCPUs, 104 GB of
• DCreate a SQL Server 2019 Enterprise on High Memory machine type with 16 vCPUs, 104 GB of

• A
  4% (1)
• B
  11% (3)
• C
  82% (23)
• D
  4% (1)

Explanation

The on-premises workload peaks at 25,000 read IOPS, so the Cloud SQL instance must be sized to meet or exceed that. In Cloud SQL, SSD storage provides 3 IOPS per GB provisioned, up to a maximum of 60,000 IOPS. To sustain 25,000 IOPS, approximately 8,300 GB (~8.3 TB) of SSD storage is required. A High Memory machine type with 16 vCPUs and 104 GB RAM provides sufficient compute headroom for the IOPS workload. Since the on-premises workload runs SQL Server 2019 Standard Edition, migrating to Enterprise (Option D) introduces unnecessary licensing cost. Option A (4 vCPUs) is underpowered for 25,000 IOPS. Option B may differ in storage sizing. Option C represents the correct balance of machine type, memory, and storage to maximize read performance at this IOPS level.

No community discussion yet for this question.