Database workloads are very diverse. While most database servers are lightly loaded, larger database workloads can be resource-intensive, exhibiting high I/O rates or consuming large amounts of memory. With improvements in virtualization technology and hardware, even servers running large database workloads run well in virtual machines. Servers running Microsoft's SQL Server, among the top database server platforms in the industry today, are no exception. An important consideration in consolidation scenarios is application performance when packing multiple virtual machines on a single hardware platform. Application performance in virtual machines should continue to meet or exceed required service levels. That is to say, the virtual platform should:
Be scalable.
- Ensure that all virtual machines get resources in proportion to their load levels up to specified resource limits.
- Provide performance isolation for each virtual machine running on a host.
- Ensure that the overall load of a host will have minimal impact on the performance of applications running in individual virtual machines hosted on that host.
This paper demonstrates the ability of VMware® ESX 3.5 to scale while guaranteeing fairness and isolation under a demanding SQL Server load. Experiments discussed in this paper involve virtual machines demanding system resources as their numbers increase, virtual machines with varying degrees of load contending for finite system resources, and runaway virtual machines attempting to demand additional system resources due to increasing load. In all cases ESX 3.5 meets or exceeds the most demanding needs.
To learn more and to read the entire article at its source, please refer to the following page, "SQL Server Workload Consolidation for VMware ESX 3.5" White Paper Download Page
Article Tags