Both VMs hosting a SQL Server instances with a database in Availability Group are initially located within the same on-premises datacenter and vSphere HA Cluster, and are configured as follows:

  • 4 vCPU and 8 GB of RAM (within pNUMA of the hosting ESXi host)

  • Database disk placed on separate PVSCSI controller

  • Windows Server 2016 SP1 Operating System

  • Microsoft SQL Server 2016 SP1 RDBMS

  • A database withNVDIMM configured for HA using the synchronous-commit availability mode

The target SDDC in VMware Cloud on AWS (the host for the migrated workload) is configured as a stretched cluster spread between two AZs:

 

All best practices for hosting SQL Server workloads on VMware SDDC were followed as outlined in Architecting Microsoft SQL Server on VMware vSphere — Best Practices Guide.

The High-Level Solution Architecture is depicted below:

check-circle-line exclamation-circle-line close-line
Scroll to top icon