SQL Server and the “Lock pages in memory” Right in Windows Server | Glenn Berry's SQL Server Perform

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 to do this

sqlserverperformance.wordpress