When CPU Hot Add is disabled, performance increases 2 to 8 percent.

CPU Hot Add Performance in vSphere 6.7

posted

Leaving CPU Hot Add at its default setting of disabled is one of the performance best practices that we have for large VMs. From the Performance Best Practices Guide for vSphere 6.7 U2: CPU Hot Add is a feature that allows the addition of vCPUs to a running virtual machine. Enabling this feature, however, disables Read more...
Generational SQL Server DB Host Power and Performance/watt

SQL Server VM Performance with VMware vSphere 6.5

posted

Achieving optimal SQL Server performance on vSphere has been a constant focus here at VMware; I’ve published past performance studies with vSphere 5.5 and 6.0 which showed excellent performance up to the maximum VM size supported at the time. Since then, there have been quite a few changes!  While this study uses a similar test Read more...
Generational performance improvement from old study to new study

SQL Server VM Performance on VMware vSphere 6

posted

Last October, I blogged about SQL Server performance with vSphere 5.5 using a four-socket Intel Xeon processor E7 based host.  Now that vSphere 6 is available, I’ve run an updated set of tests using this new release, on an even more powerful host, with Xeon E7 v2 processors.  A variety of virtual CPU (vCPU) and Read more...
8 x 8 vCPU VM throughput

Monster Performance with SQL Server VMs on vSphere 5.5

posted

VMware vSphere provides an ideal platform for customers to virtualize their business-critical applications, including databases, ERP systems, email servers, and even newly emerging technologies such as Hadoop.  I’ve been focusing on the first one (databases), specifically Microsoft SQL Server, one of the most widely deployed database platforms in the world.  Many organizations have dozens or Read more...