• subscribe
June 27, 2008 12:00 AM

Virtualization Shootout: Hyper-V vs. ESX Server 3.5

These products deliver excellent performance and make it easy to virtualize your SQL Server instances
SQL Server Pro
InstantDoc ID #99218

Due to time constraints, I gave up on the Server Core installation and ran Hyper-V on a full Server 2008 installation using the local console for management. After installing Server 2008, I installed the Hyper-V role using Server 2008’s Server Manager. Not counting the failed Server Core installation attempt, it took three reboots before the server was fully set up.

Figure 2 shows Hyper-V’s management console. Theoretically, multiple Hyper-V server instances can be managed in the left pane of Hyper-V Manager, although I couldn’t connect to any remote servers. Selecting a server instance displays that server’s VMs in the Virtual Machines pane. You can then manage the VMs by right-clicking them and selecting options from the context menu. I found Hyper-V Manager to be less functional and less well thought out than ESX Server 3.5’s management console. I thought that the Snapshot pane in particular was poorly positioned, and it seemed that everything was forced to fit inside the generic Microsoft Management Console (MMC) 3.0 framework. Although Hyper-V Manager doesn’t show detailed server performance information, basic VM management using the management console was functional and easy.

SQL Server VM Performance
Performance is where the rubber meets the road. To compare the performance of ESX Server 3.5 and Hyper-V, I created four VMs, each of which was running Server 2008 Enterprise Edition configured with 512MB of RAM running SQL Server 2005 Enterprise Edition SP2. For each platform, I used the default virtual hard disk configuration options. Four Server 2008 instances can be simultaneously active as VM guests with no additional Server 2008 licensing costs. (I’ll discuss licensing in more detail later.)

All of my testing was conducted on an HP ProLiant ML370 G5, which is a rack-mounted 4U server. My test unit included two Quad-Core Intel Xeon processors running at 1.86 GHz on a 1066 MHz front-side bus. The ProLiant ML370 G5 came equipped with 8GB of RAM and eight 72GB 15,000 RPM drives configured as a RAID array.

For the test workload I used 27 different queries running against the sample AdventureWorks database. Although the bulk of the workload was data retrieval, the batch also contained a couple of computational loops and four SELECT INTO statements to add some computational and data modification operations. A think time of three seconds was inserted between each database interaction.

The workload was executed from four physical client machines, each of which used Microsoft’s sqlcmd utility to launch the workload against all four SQL Server systems running as VMs. Then the client paused for three seconds. This process was repeated 10 times, creating a total of 40 running jobs from each of the four clients where each client was running 10 separate connections per server. This test revealed how each of the virtualization platforms was able to respond to increasing workloads and to the total workload with all four virtualized SQL Servers actively servicing 40 queries. The final performance measurement that I used was the average time required to complete the measured workloads. The tests were run multiple times and the results were averaged. Web Figure 2 compares the overall performance of the two platforms.

As you can see in Web Figure 2, the results were surprisingly close, with ESX Server 3.5 providing better performance under the tested workload. Although ESX Server 3.5 edged out Hyper-V by 4 percent in the performance tests I ran, Hyper-V made a competitive showing in spite of the fact that it was prerelease code. I expect the final release will provide very similar performance results. I also expect that the glaring remote management problems will be corrected in the final release. However, I don’t expect Hyper-V’s management console to be improved to match ESX Server 3.5’s Virtual Infrastructure Client. You should bear in mind that although these results were representative of the test workload that I ran, it’s possible that different workloads and environments could produce varied results.

Virtualization and Licensing
Price is another area in which there’s a significant difference between ESX Server 3.5 and Hyper-V. ESX Server 3.5 has always been a chargeable product and is the staple of VMware’s product line. In my comparison of each of the product’s licensing and pricing structures, I used VMware Infrastructure Foundation 3, which includes the following components:

  • ESX Server 3.5
  • VMware Virtual Machine File system (VMFS)
  • VMware SMP
  • VirtualCenter Agent
  • VMware Consolidated Backup
  • VMware Update Manager

In contrast, Hyper-V is included in Server 2008, making it essentially free to organizations running Server 2008. Because Hyper-V is a 64-bit technology, you must have x64 hardware and use one of the x64 editions of Server 2008. Hyper-V is included in Server 2008 Standard Edition x64, Server 2008 Enterprise Edition x64, and Server 2008 Datacenter Edition x64.

Microsoft does make three versions of Server 2008 that don’t include Hyper-V (aptly named Server 2008 without Hyper-V), and the price difference is negligible at only $28. Hyper-V also isn’t included in Windows Web Server 2008, Windows HPC Server 2008, or Server 2008 for Itanium-based Systems.

The pricing for the two tested configurations is shown in Web Table 2. Note that this table uses retail pricing, whereas most businesses use Microsoft’s volume licensing.

One important point to be aware of is that Server 2008 Enterprise Edition and Windows 2003 R2 allow for as many as four active virtual Windows instances with no additional costs. This licensing is the same whether you use Microsoft or VMware virtualization products. In addition, Server 2008 Datacenter Edition and Windows 2003 R2 allow an unlimited number of virtual Windows instances no matter which virtualization platform you’re using. You can also run an unlimited number of SQL Server 2005 Enterprise Edition instances on VMs no matter which virtualization technology you’re using. The end result is that the inclusion of Hyper-V with Server 2008 makes Hyper-V a less expensive virtualization option than ESX Server 3.5.

The Bottom Line
My testing revealed that both Hyper-V and ESX Server 3.5 deliver excellent levels of performance. For midsized businesses, especially those organizations just getting into virtualization, I found Hyper-V to be compelling. Being bundled with Server 2008 makes the price point very attractive and the Windows-based management tools make it easy to use. However, ESX Server 3.5’s better performance, more mature management tools, and Virtual Infrastructure 3 management suite provide a more feature-rich platform for large organizations.



ARTICLE TOOLS

Comments
  • adam
    3 years ago
    Mar 03, 2009

    I like how everyone always forgets about MS licensing. When you install the full version of Hyper-V, not the cheapo baremetal one, then all vm's need server 2008 CAL's. So if you go about virtualizing some of your older 2003 boxes on the 2008 host then you have to upgrade all your CAL's. So, now how does your Hyper-V look?

    Who would I be without providing some type of link directly to a MS article?
    Scroll down to page 11.
    http://download.microsoft.com/download/E/E/C/EECF5D44-9A88-43D8-AFDB-D2AB82BE035C/Win%20Server%20Lic%20Book%20
    customer%20hi-res.pdf

    it reads
    Q: If I move an instance of Windows 2003 to run as a virtual instance on
    a server with Windows Server 2008 Enterprise running in the physical
    operating system environment. Can I use Windows Server 2003 CALs to
    access the virtual instance of Windows Server 2003?
    A: No. Because the virtual instance of Windows Server 2003 runs on a
    Windows Server 2008 license, the user or device accessing the virtual
    instance of Windows Server 2003 needs a Windows Server 2008 CAL.

  • John
    3 years ago
    Jan 07, 2009

    Good article for someone planning to try out virtualisation. Should extend the test for SQL2008 as well.

  • Mordocka
    4 years ago
    Sep 24, 2008

    The results of this test are impossible to interpret. There is no data provided to indicate what the bottleneck was to performance that was being measured. Given the small size of the VMs (512M), it is likely that the bottleneck was Disk and not memory or CPU. It would be far more interesting to create 2G VMs and measure performance with 1, 2, 3, 4, 5... VMs running under each OS. It is unlikely that the 4th VM would even start up on HyperV, yet it would run perfectly on ESX. It would be further interesting to see just how many VMs could be loaded on ESX before the performance dropped down to that of HyperV. I suspect it would be at least 5 and quite possibly as high as 8, 10 or more. This is where the real difference between HyperV and ESX reside. The other poster is also correct in that ESXi (free) would be the fairer comparison given the parameters of the tests. ESXi would thus be $28 cheaper and even give slightly better performance than ESX. It would be stupid to pay for Foundation if the features of Virtual Center were not part of the test. Note that HyperV has none of the features of Virtual Center what-so-ever. Another poster is looking for easier hardware replacements in the future. HyperV will not provide this feature with the drivers residing inside the VMs. Only ESX/ESXi provides driver virtualization that will give portability to next generation equipment requiring new drivers. Bottom Line, comparing HyperV and ESX with Virtual Center is an unfair comparison. ESX with VC is a Datacenter OS that provides optimization of Compute resources across the entire Datacenter. HyperV has absolutely no real-time Datacenter-wide capabilities.

  • rschmidt,rschmidt
    4 years ago
    Aug 13, 2008

    I wonder if your not comparing apples and oranges. I think a better comparison would be Hyper-V vs ESX 3.5i since you are not using any of the advanced features of VI3 in your examples. ESX 3.5i is currently free so your cost comparison would change.

  • Jim
    4 years ago
    Aug 05, 2008

    We are looking at virtualization technologies here. All of our servers are exceptionally old and in dire need of replacement but the cost is prohibitive without virtualization. Our new VP has also indicated that he run everything virtualized so hardware replacements in the future are less painful. This article does a great job of comparing the two leading products and will weigh heavily into our decision as to which direction we will go.

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...