My colleague Bert de Reus sent me a stimulating email. He has been implementing Hyper-V R2 at a customer site with HP ProLiant G6 servers and HP LeftHand storage (virtualization bundle).
The customer had an aging HP ProLiant ML350 G3 with seven U320 SCSI disks and Microsoft SQL Server 2005 holding several databases. A typical query on a 70GB database located on a Hyper-V Cluster Shared Volume (CSV) lasted 1 hour and 38 minutes.
The newly implemented infrastructure consists of a 3-node Hyper-V R2 cluster using HP ProLiant DL380 G6 with 8 cores and 64GB of memory and two HP LeftHand P4500 boxes with a total of 24 450GB 15K SAS disks. The databases were moved to a VM with 4 vCPU’s and 4GB of RAM. The operating system was Windows Server 2008 x64 SP2 and the database was leveled up to SQL Server 2008 x64 SP1.
The exact same query took only 7 minutes.
The customer was extremely impressed with this 14-fold performance improvement.
Extra information (November 11th, 2009)
A second database test was even more rewarding: A query which normally took 2,5 hours was cut back to only 12 minutes (15.8x faster)
Databases were consolidated from several physical servers to four virtual SL Server 2008 SP1 x64 virtual machines.