Virtualise and Consolidate SQL Server with confidence on Windows Server 2012 Hyper-V


The study by ESG Labs, demonstrates performance, scalability, and low overhead of Hyper-V can be used to reduce costs and improve the manageability, flexibility, and availability of SQL Server workloads. Through their testing, ESG Lab confirmed that the performance and scalability of Windows Server 2012 with Hyper-V makes it possible to consolidate a tier-1 database application workload with confidence. With the ability to allocate up to 64 vCPUs, processor heavy workloads previously not considered for virtualization can now leverage the scalability potential of Windows Server 2012 with Hyper-V. ESG Labs measured a six times performance improvement with five-time faster response times for a CPU intensive OLTP workload with a 75,000 customer database.

Key points:

  • With Windows Server 2012 Hyper-V’s new support for up to 64 vCPUs, ESG Lab took an existing SQL Server 2012 OLTP workload that was previously vCPU limited and increased the performance by six times, while the average transaction response times improved by five times.
  • Manageably-low Hyper-V overhead of 6.3% was recorded when comparing SQL Server 2012 OLTP workload performance of a physical server to a virtual machine configured with the same number of virtual CPU cores and the same amount of RAM.


ESG Labs SQL Server 2012 on Windows Server 2012 Two Page Summary Report:

ESG Labs SQL Server 2012 on Windows Server 2012 Full Report:

Comments (3)

  1. WQ says: Sure, the process of flinging a spinnerbait may catch a rogue fish off of nothing here and there, but I’ve found that during the course of the average true cover-seeking day, your only looking for a few extra bites from “between” bass. I’d rather be locked and loaded for the gentle pitch, then carelessly unleashing the firing– squad. What I mean is that in most cases I’d rather be putting along “between” at a moderate pace with the same jig in my hand that I had success with on
    http://www.burberry– the docks all day, and looking for that unique cast/pitch to something

  2. aw says:

    I think your article is very useful, it might be in more detail further suggest the method clearer method, can be of several categories that you created or any of several methods that should be done in the process of it, thank you very much lokerius somone I need beberapa langka sebenaernua ada rasa sama kita tapi sebenarnya tahukan anda sebutan dari kita adalah anugrah yang dapat kita rahasia itu hanya ada dalam sebuah cerita tentang kita yah begitulah hidup hidup itu cuma sekali tidak ada keduakalinya maksudnya cuma hidup di dunia rahasia semua kediupan more release raksa tui end dend nomore subject

  3. aw says: