Home > Hyper-V, Hyper-V R2, Virtualization > SQL Server / Dynamic Memory Whitepaper

SQL Server / Dynamic Memory Whitepaper

Today SQL Server team published a whitepaper about considerations for Dynamic Memory in SQL Server VMs.

You can download the paper from:

Running SQL Server with Hyper-V Dynamic Memory – Best Practices and Considerations

Or

http://sqlcat.com/whitepapers/archive/2011/08/01/running-sql-server-with-hyper-v-dynamic-memory-best-practices-and-considerations.aspx

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 document 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.

 

I am not SQL Expert but I will try to provide any hints or comments on this Whitepaper

 

Enjoy it Smile

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: