What is the use of Lock pages in Memory setting?> What happens if we enable Lock Pages in Memory setting
asked Mar 18 '11 at 02:29 AM in Default
Lock Pages in Memory is a Windows permission to allow the named user to keep its data space in RAM rather than being paged out, to improve performance.
However, if you enable this for the SQL Server service user, you should also put a hard limit on the amount of memory that SQL Server should allocate to itself, to make sure that Windows processes can still get a look-in!
You should team this with use of AWE (Address Windowing Extensions) (on 32-bit servers).
[See documentation for SQL2008]: http://msdn.microsoft.com/en-us/library/ms190730.aspx
This article and the KB articles should help:
[How to determine the appropriate page file size for 64-bit versions of Windows]: http://support.microsoft.com/kb/889654/
answered Mar 22 '11 at 04:09 AM