SQL server performance

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...

Performance of SQL Server 2017 for Linux VMs on vSphere 6.5

posted

Microsoft SQL Server has long been one of the most popular applications for running on vSphere virtual machines.  Last year there was quite a bit of excitement when Microsoft announced they were bringing SQL Server to Linux.  Over the last year Microsoft has had quite a bit of interest in SQL Server for Linux and it was Read more...
Generational SQL Server VM Database Performance

Updated – SQL Server VM Performance with vSphere 6.5, October 2017

posted

Back in March, I published a performance study of SQL Server performance with vSphere 6.5 across multiple processor generations.  Since then, Intel has released a brand-new processor architecture: the Xeon Scalable platform, formerly known as Skylake. Our team was fortunate enough to get early access to a server with these new processors inside – just 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...

VMware vCloud Air Database Performance Scalability with SQL Server

posted

Previous posts have shown vSphere can easily handle running Microsoft SQL Server on four-socket servers with large numbers of cores—with vSphere 5.5 on Westmere-EX and more recently with vSphere 6 on Ivy Bridge-EX.  We recently ran similar tests on vCloud Air to measure how these enterprise databases with mission critical performance requirements perform in a 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...

Virtualizing SQL Server-based vCenter database – Performance Study

posted

vSphere is an industry-leading virtualization platform that enables customers to build private clouds for running enterprise applications such as SQL server databases. Customers can expect near-native performance from their virtualized SQL databases when running in a vSphere environment. VMware vCenter Server, the management component of vSphere, uses a database to store and organize information related Read more...