VMware has released a paper titled: "Performance and Scalability of Microsoft SQL Server on VMware vSphere 5.5". The Paper which contains 33 pages demonstrates that large Microsoft SQL Server databases can achieve great performance and fully utilize current-generation server and storage technology using VMware vSphere 5.5.
The paper contains the following sections:
- Executive Summary
- Test Environment
- Comparing Physical vs. Logical Processors
- Maximum Throughput Tests
- Virtual NUMA, Cores per Socket Testing
- Latency Sensitivity tests
- Best Practices
The paper details a variety of vCPU and virtual machine quantity combinations, all of which show that vSphere can handle hundreds of thousands of online transaction processing (OLTP) database operations per minute.