Performance Characterization of Microsoft SQL Server on VMware vSphere 6.5

Version 5

    VMware vSphere 6.5 continues to increase the maximum sizes supported for both physical hosts (576 logical CPUs and 12TB of RAM) and virtual machines (128 virtual CPUs and 6TB of RAM). In this paper, an online transaction processing (OLTP) benchmark, DVD Store 3, was used to characterize performance and power across five generations of 4-socket Intel EX servers hosting “monster”-sized Microsoft SQL Server 2016 database VMs. The results show vSphere is capable of fully utilizing current generation server and storage technology, achieving great database performance.

     

    Previous versions of this paper are also attached.

     

    Download the latest paper (sql-server-vsphere65.pdf), below.