Q and A: Do I need to run "sp_configure ‘awe enabled’, 1" to make 64 bit version of SQL Server use locked pages?

The answer is No.  The source of possible confusion came from one of my previous posts: http://blogs.msdn.com/slavao/archive/2005/11/15/493019.aspx. I apologize for the confusion. In order to make 64 bit version of SQL Server leverage locked pages all you need to do is to give lock pages in memory privilege to an account under which SQL Server process runs. You don't need to run  "sp_configure 'awe enabled', 1".

Comments (2)
  1. ajayciti says:

    Thanks for writing something abt this. I am building a 64 bit box at this moment with locked pages feature, but have kept AWE setting to default, i.e 0. Hope that should be an issue at later stage. As far as I know SQLServer 64 bit, anyway uses AWE APIs to manage the memory even if AWE is set to 0. Pls correct me if I am wrong.

  2. Anwar says:

    Hi Slava, I got a question, after assign the privilege to the SQL account on the Policy Rights, Is necessary restart the SQL Server Service to take effect?


Comments are closed.

Skip to main content