Paper: Running SQL Server with Hyper-V Dynamic Memory

Posted by Kenneth van Surksum   |   Tuesday, August 23rd, 2011   |  

Microsoft has released a whitepaper titled: "Running SQL Server with Hyper-V Dynamic Memory". The paper which contains 39 pages covers how to configure Dynamic Memory, introduced with the release of Windows Server 2008 R2 Service Pack 1, when running SQL Server workloads on top of Hyper-V.

For testing the scenarios a two-node IBM x3850 X5 Server with Windows Server 2008 R2 failover cluster was used, with 32 physical processor cores and 128 GB of RAM. Storage was provided by a dedicated HDS AMS2500 storage system.


The paper covers the following topics:

  • Basics of Dynamic Memory and SQL Server memory management
  • Core test scenario’s and workloads
  • When will Dynamic Memory help SQL Server workload
  • Impact of Virtual Memory removal on SQL Server workloads
  • Considerations for planned and unplanned failover
  • Memory Rebalancing Behavior, Impact on SQL Server Workload Performance, and Impact on the Host
  • Impact of Increased Workload on Memory Consumption

Conclusions from the paper:

• Run SQL Server with the Lock pages in memory user right to provide better stability to the SQL Server workload during memory removal operations.

• Ensure that the total of Startup Memory settings for the virtual machines is configured to be lower than host’s physical memory so that all virtual machines can start in the event of an unplanned failover.

• When possible, use SQL Server memory management tools (sp_configure ‘max server memory’) to enable more orderly live migrations.

• Disabling NUMA spanning has some advantages to live migration scenarios and may offer some performance advantage due to locality of memory allocations (this is not illustrated or measured as part of this paper, however).

• Use memory weight to selectively adjust assigned memory to certain virtual machines dynamically.

• A recommended starting point for the memory buffer setting is 5 percent; you can adjust it based on your memory rebalancing needs.

• Many of the optimal settings and behaviors depend on your workload. You may need to perform further experiments and tests to determine what works best for any given deployment.

Labels: ,

blog comments powered by Disqus Newest articles
Release: VMware vRealize Log Insight 4.5

June 13th, 2017

Log Insight is a log aggregation, management and analysis tool, that VMware first introduced in 2013 and considered a competitor of Splunk.
Yesterday VMware announced the release of version 4.5, available for…

Release: VMware vRealize Automation 7.3

June 6th, 2017

Today VMware announced the latest release of its cloud management platform vRealize Automation, former vCloud Automation Center.
VMware vRealize Automation 7.3 release notes can be found at this link.


Paper: Introducing the NSX-T Platform

February 9th, 2017

“We see greater potential strategic opportunity in NSX over the next decade than our franchise product vSphere has had for the past decade.”
said VMware’s CEO Pat Gelsinger talking about…

Paper: VMware vSphere Virtual Machine Encryption Performance

November 22nd, 2016

Encryption of virtual machines is something that has been requested for years by the security community. VMware continued to postpone its implementation due to the negative operational impact that many…

Quest Software leaves Dell

November 1st, 2016

In September 2012 Dell announced to have completed the acquisition of Quest Software, a Californian company with an history in systems management, security, business intelligence and, falling back in our…

Citrix announces Q3 2016 results

October 21st, 2016

Citrix announced its financial results for third quarter 2016.
The revenues for the second quarter were $841 million for an increase of 3% compared to Q3 2015.
Net income was $132…

Release: VMware vSphere 6.5 & Virtual SAN 6.5

October 19th, 2016

2016 edition of VMworld US has been quite turbulent, on the other hand during VMworld Europe, happening these days in Barcelona, the company announced a few more products for the…

Release: VMware vRealize Log Insight 4.0

October 18th, 2016

Log Insight is a log aggregation, management and analisys tool, that VMware first introduced in 2013 and now is usually compared with Splunk.
Yesterday VMware announced Log Insight’s new major…

Release: Windows Server 2016 with support for Window Server & Hyper-V containers

October 13th, 2016

Yesterday Microsoft announced the general availability of Windows Server 2016 which the company defines as a cloud-ready OS.
Beside fancy definitions, one of the most relevant perks of this release…

Release: Oracle VM 3.4.2

September 22nd, 2016

During Oracle OpenWorld 2016 the company released version 3.4.2 of its enterprise virtualization solution.
Oracle VM is available for both x86 and SPARC based processor architectures and uses the Xen hypervisor…

VMworld US 2016 Wrap-up

September 1st, 2016

Today was the last day of VMware’s flagship conference VMworld in Las Vegas, an highly controversial edition which left a good chunk of the audience disoriented if not properly disappointed….

Gartner releases its Magic Quadrant for Cloud Infrastructure as a Service for 2016

August 11th, 2016

Last week Gartner updated its Magic Quadrant for Cloud Infrastructure as a Service (IaaS) for the year 2016. The Magic Quadrant for the year 2015 was released in May last year…

Release: Ansible Tower 3 by Red Hat

August 2nd, 2016

Ansible is one of the four main players in the automation market, younger then the well known Chef and Puppet, has been launched in 2013 in Durham, N.C. and acquired…

IBM announces earnings for Q2 2016

July 19th, 2016

Yesterday IBM announced its results for Q2 2016.

If we compare with the same quarter in 2015 earnings per share, from continuing operations, decreased 22%. Net income, from continuing operations,…

Monthly Archive