SQL Server Performance

Should I use Lock Pages in Memory for SQL Servers on Virtual Machines?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Mar 9, 2014.

  1. Trev256b Member

    I have spoken to three DBAs and they all say something different - which of the following is true: a, b, or c and why?
    a) You should not use Lock Pages in Memory for a SQL Server on a virtual machine.
    b) You should use Lock Pages in Memory for a SQL Server on a virtual machine.
    c) Nobody knows whether you should use Lock Pages in Memory for a SQL Server on a virtual machine!
  2. melvinlusk Member

  3. Trev256b Member

    Thanks Melvin - I will read this and come back to you. The general summary is don't use it and let VM do the work. I will update you with my update in about a week - v busy! :)

Share This Page