VMware Cloud on AWS, powered by VMware Cloud Foundation™, integrates VMware flagship compute, storage, and network virtualization products—VMware vSphere, VMware vSAN™, and VMware NSX®—along with VMware vCenter Server® management. It optimizes them to run on elastic, bare-metal AWS infrastructure. With the same architecture and operational experience on premises and in the cloud, IT teams can now get instant business value via the AWS and VMware hybrid cloud experience.

The VMware Cloud on AWS solution enables customers to have the flexibility to treat their private cloud and public cloud as equal partners and to easily transfer workloads between them—for example, to move applications from DevTest to production or burst capacity. Users can leverage the global AWS footprint while getting the benefits of elastically scalable SDDC clusters, a single bill from VMware for its tightly integrated software plus AWS infrastructure, and on-demand or subscription services.

A business-critical application that is often run on vSphere today is Microsoft SQL Server, which is “one of the most widely deployed database platforms in the world, with many organizations having dozens or even hundreds of instances deployed in their environments.” Consolidating these deployments onto modern multi-socket, multi-core, multi-threaded server hardware as virtual machines on vSphere is an effective solution.

Scale-Out Performance

Another way to measure performance is with multiple VMs running at the same time, which is known as scaleout performance. The setup is the same as the previous, single VM scale-up tests, but the workload driver system now spreads the worker threads across a number of target SQL Server database VMs simultaneously. The database VMs are spread out across the cluster, based on the best load balancing as determined by vSphere’s Distributed Resource Scheduling (DRS). The total number of OPM achieved across all the SQL Server database VMs is then reported for each set of VMs.

Currently, VMware Cloud on AWS supports up to 16 hosts per cluster and up to 10 clusters per SDDC. In these tests, we used one cluster with only 3 hosts in our SDDC. The performance of the scale-out tests is largely due to the number of hosts. If more hosts were added to the SDDC, then more VMs could be run and the total amount of throughput achieved would be higher. An SDDC with more physical hosts would be capable of achieving higher scale-out performance than what we measured with the 3 host SDDC for these tests.

VMware Cloud™ on AWS brings VMware’s enterprise software-defined data center (SDDC) to the AWS Cloud. It enables customers to easily migrate their existing virtual infrastructures to seamlessly run their business-critical applications like SQL Server, in the cloud, using the same VMware vSphere® environment that they have traditionally used on-premises.

The purpose of this paper is to answer a question that many customers have today: how do workloads that have traditionally been run in an on-premises infrastructure perform when transitioned to the cloud? The benchmark results show the answer is SQL Server continues to perform great within a VMware Cloud environment, for both small and large OLTP database VMs/workloads.

To read full download the whitepaper:
Performance Characterization of Microsoft SQL Server Using VMware Cloud on AWS