Question :This message appears in the SQL Server Logs “Cannot use Large Page Extensions: lock memory privilege was not granted”. It’s a SQL Server 2008 64 bit on Windows 2008 R2 64-bit Operating System. The Server memory is 64 GB.
AWE is not enabled and the SQL Server Maximum Server Memory is 47 GB
Should I be worried?
Answer : It depends. When SQL Server is booted - the SQL Server decides if large page support is used. The Windows memory (x64) is 4kb versus 2MB for large pages.
The decision is based on the three criteria being true :
1) The server having at least 8GB memory
2) SQL Server Enterprise Edition
3) Lock Pages in Memory is set
Lock pages in memory keeps the pages in memory and doesn’t allow the OS to page them out. It is possible performance is improved – but does require testing.
To view large page allocation use the sys.dm_os_process_memory DMV.
For more SQL Server memory discussion read SQL Server 2005 memory configuration management.