http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspxIMPORTANT: The following KB article adds support for Locked Pages to SQL Server Standard Edition http://support.microsoft.com/kb/970070 NOTE: I've updated this because of some questions about 32bit systems. Some who attended one of my talks at the recentenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#5509641Thu, 18 Oct 2007 18:26:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:5509641Techy News Blog » Blog Archive » Do I have to assign the Lock Pages in Memory privilege for Local System?<p>PingBack from <a rel="nofollow" target="_new" href="http://www.artofbam.com/wordpress/?p=10141">http://www.artofbam.com/wordpress/?p=10141</a></p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#5547481Sat, 20 Oct 2007 17:46:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:5547481mbourgon<p>I was trying to get AWE and Database Mail enabled on a x64, 2005 box. &nbsp;The machine was set up to use the NetworkService account, and I couldn't get AWE enabled without enabling the lock pages in memory setting. &nbsp;What was doubly odd was that none of the other sp_configure settings that I changed took effect prior to enabling that. &nbsp;RECONFIGURE would say that the Lock Pages In Memory had to be set first, and wouldn't enable mail until that was done. &nbsp;</p> <p>Just found that terribly odd.</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#5631852Tue, 23 Oct 2007 23:33:16 GMT91d46819-8472-40ad-a661-2c78acb4018c:5631852alpha1105omega<P>i have lock pages in memory set in gpedit..</P> <P>however i cannot locate this messsage in sql errorlog (Log File Viewer in SSMS or ERRORLOG files) "Using locked pages for buffer pool"..</P> <P>???</P> <P>Are you positive that "lock page in memory" privilege is set for the account that that the SQL Server Service is logged on with? Also, this only for Enterprise Edition.</P> <P>bob ward</P>http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#5634904Wed, 24 Oct 2007 01:53:00 GMT91d46819-8472-40ad-a661-2c78acb4018c:5634904alpha1105omega<P>my 64bit says "Using locked pages for buffer pool"..</P> <P>but cant find the message in 32bit however it says address windowsing extension..is enabled......</P> <P>is it only applies to 64bit?</P> <P>This is a great question and has caused me to go back and look at how we print this messagei in the ERRORLOG. I'm going to update the blog with new information that covers your questions and sets a few other facts straight.</P> <P>bob ward</P>http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#7009744Sun, 06 Jan 2008 23:49:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:7009744Grumpy Old DBA<p>There is an almost constant stream of posts on forums asking about configuration of SQL Server 2005 memory,</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#7221954Thu, 24 Jan 2008 16:31:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:7221954Bob Duffy's Blobby Blog<p>A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is that</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#8172503Wed, 12 Mar 2008 21:52:45 GMT91d46819-8472-40ad-a661-2c78acb4018c:8172503Dynamics Ax Performance team<p>Welcome to the Dynamics Ax Performance Team's blog. We're putting together a team introduction and hope</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#8344750Mon, 31 Mar 2008 01:20:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:8344750Bob Duffy's Blobby Blog<p>A lot of customers have been asking me if they need to use Enterprise Edition. the basic answer is that</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#9446494Thu, 26 Feb 2009 15:59:44 GMT91d46819-8472-40ad-a661-2c78acb4018c:9446494SQL Administration<p>View products that this article applies to. On This Page SUMMARY SYMPTOMS CAUSE WORKAROUND MORE INFORMATION</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#9526261Wed, 01 Apr 2009 14:26:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:9526261Action plans and problem solving<p>You might have seen these two messages logged in the SQL Server ERRORLOG files: - Cannot use Large Page</p> http://blogs.msdn.com/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx#9763108Tue, 16 Jun 2009 23:58:36 GMT91d46819-8472-40ad-a661-2c78acb4018c:9763108Pin Wang's AX Blog<p>Assumptions : Dedicated SQL Server 2005 Server (does not run any other major applications besides SQL</p>