This document describes the steps and tasks involved in designing and configuring a sample Azure VMware solution infrastructure to optimally support a virtualized production Microsoft SQL Server workload. It is intended to provide a representative list of configuration options, architectural guidelines, and operational considerations based on the standard practices documented in VMware’s published best practices for virtualizing Microsoft SQL Server workloads on the VMware vSphere® platform.
To provide a broader view of these options, this document describes a 3-node cluster of Microsoft SQL Server instances configured as follows:
- A 2-node failover clustering instance (FCI) configuration consisting of two Windows Server 2019 VMs hosting an instance of Microsoft SQL Server and configured for high availability.
- A 2-node Always On availability group (AG) consisting of two Windows Server 2019 VMs hosting a high-availability configuration of a database.
- One of the VMs in both scenarios described above is simultaneously participating as a Node in each of the configurations.
Always refer to the following architectural and best practices guides for the latest and most comprehensive information when designing your VMware vSphere-based hybrid cloud infrastructure. These documents (individually and collectively) will remain the authoritative sources for information related to running Microsoft SQL Server workloads on the vSphere platform and any hybrid- or public-cloud based derivative:
- SQL Server on vSphere Best Practices Guide
- Planning Highly Available, Mission Critical SQL Server Deployments with VMware vSphere
- Considerations for running Microsoft SQL Server workloads on VMware vSAN
- Architecting Microsoft SQL Server on VMware vSphere — Best Practices Guide