SQL Server Performance

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, May 21, 2008.

  1. Anonymous New Member

    The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is required by SQL Server service account to allow locking of physical memory preventing OS paging of the locked memory. Within 32 bit architecture systems irrespective of edition i.e., standard, enterprise and developer editions, this privilege needs to be granted...(<a href="http://sqlserver-qa.net/blogs/x64/archive/2008/05/21/4293.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4293" width="1" height="1">

Share This Page