Microsoft Releases Best Practices for Virtualizing SQL Server 2012
- select the contributor at the end of the page -
Microsoft SQL Server 2012 and Windows Server 2012 provide a host of new features that can be used to effectively virtualize demanding database workloads that previously were not considered for virtualization. This guide explains these new features in the context of how organizations should consider virtualizing SQL Server 2012 on Windows Server 2012 and the benefits of managing this virtualized environment with Microsoft System Center 2012. -- Executive Summary
The first portion of the paper is as to be expected an executive summary and explanation of why virtualization is generally a good thing, probably the least informative part of this document. However, they then go on to make a strong case for how the combination of Windows Server 2012, SQL Server 2012, and System Center 2012 work together to create a fully integrated virtualization solution.
- Better Scalability: Higher capacity vCPUs (up to 64), memory (up to 1 TB), and virtual machine density (up to 8,000 per cluster).
- Better Performance: Hyper-V support on Non-Uniform Memory Access (NUMA) and Fibre Channel.
- Better Availability: Faster and simultaneous live migration and dynamic quorum support in SQL Server AlwaysOn cluster.
- Better Manageability: Same management tool (System Center) for SQL Server virtual machines in both private and public clouds.
Throughout the document, best practices are called out such as using Windows Server Core to reduce the potential attach surface of the server, running Hyper-V on SLAT-capable processors and hardware, and letting Windows Server 2012 handle page file sizing.
The report goes into great detail to explain how the different storage options provide performance that rivals native disks using simple/striped, mirrored, and parity spaces.
If you're interested in learning more about virtualizing SQL Server 2012, you can find the document here.