Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have several SQL 2005 instances that are in a process of being virtulizaed and upgraded to SQL 2008 R2 running VMWare vSphere 5.1.

Our VMWare admin told me that in our org they do not over allocate memory to the guests. Per him though VMWare recommend to enable "Lock Pages in Memory" for SQL server running on virtual machines.

Does "Lock Pages in Memory" is enabled for SQL Server running on virtual machines?

share|improve this question
I think this answers your question… – Phil Sep 29 '12 at 13:57
up vote 1 down vote accepted

I believe the general consensus these days is that if you are deploying onto a modern OS such as Windows 2008 R2, and the server is dedicated to SQL Server, then lock pages in memory is generally not required. The modern OS is much better at managing memory than earlier versions, even Windows 2003. However, it'll be prudent to test both scenarios.

share|improve this answer
+1 just for mentioning testing. Validate that it is needed before turning it or anything else on. Agreement both OS and SQL Server have advanced to handle the problems that used to require this being turned on. – Shawn Melton Sep 29 '12 at 18:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.