I thought I’d share with you, some useful resources around the virtualising of SQL 2008 R2, on Hyper-V R2, and the kind of performance you can expect from this combination of technologies.
High Performance SQL Server Workloads on Hyper-V White Paper
This whitepaper focuses on the advantages of deploying Microsoft SQL Server database application workloads to a virtualisation environment using Microsoft Windows Server 2008 R2 Hyper-V. It demonstrates that Hyper-V provides the 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. This paper assumes that the reader has a working knowledge of virtualisation, Windows Server Hyper-V, SQL Server, Microsoft System Center concepts and features.
The 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 the parent OS, networking, VHD considerations, and more.
Thanks to Matt @ MSFT for this.