次の方法で共有

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: https://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

  • Anonymous
    July 15, 2009
    The comment has been removed
  • Anonymous
    February 15, 2010
    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? Thanks!