SQL Server 2008 R2: High Performance SQL Server Workloads on Hyper-V White Paper and Resources

Microsoft published a whitepaper focuses on advantages of deploying SQL Server database application workloads to a virtualisation environment using Windows Server 2008 R2 Hyper-V. It demons that Hyper-V provides performance and scalability needed to run complex SQL Server workloads in certain scenarios. It also shows how Hyper-V can improve performance when used in conjunction with […]

Microsoft published a whitepaper focuses on advantages of deploying SQL Server database application workloads to a virtualisation environment using Windows Server 2008 R2 Hyper-V. It demons that Hyper-V provides performance and scalability needed to run complex SQL Server workloads in certain scenarios. It also shows how Hyper-V can improve performance when used in conjunction with advanced processor technologies. Paper assumes that the reader has a working knowledge of virtualisation, Hyper-V, SQL Server, System Center concepts and features. Whitepaper discusses a number of different tests that were performed, in some detail, yet also, from page 30, you can also start to read about the best practices for running workloads like SQL on Hyper-V. The best practices section provides guidance around configuration for parent OS, networking, VHD considerations, and more.

More Info: Download

SQL Server 2008 Virtualization

SQL Server Analysis Services Virtualization

[Source]