Tag Archives: Lock pages in memory

SQL Server and the “Lock pages in memory” Right in Windows Server

Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL Server community and within Microsoft about whether and when you should enable this setting. Before you decide whether you want … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 58 Comments