The SQL CAT team has published a new whitepaper regarding dynamic memory best practices with Hyper-V… If your virtualizing SQL I would highly recommend taking a look!
Summary: Memory is a critical resource to Microsoft SQL Server workloads, especially in a virtualized environment where resources are shared and contention for shared resources can lead to negative impact on the workload. Windows Server 2008 R2 SP1 introduced Hyper-V Dynamic Memory, which enables virtual machines to make more efficient use of physical memory resources. Hyper-V Dynamic Memory treats memory as a shared resource that can be reallocated automatically among running virtual machines. There are unique considerations that apply to virtual machines that run SQL Server workloads in such environments. This whitepaper provides insight into considerations and best practices for running SQL Server 2008 R2 in Hyper-V Dynamic Memory configurations on Windows Server 2008 R2 SP1.
To continue reading, please download the whitepaper: http://msdn.microsoft.com/en-us/library/hh372970.aspx
Taylor Brown Hyper-V Enterprise Deployment Team firstname.lastname@example.org http://blogs.msdn.com/taylorb