Lock pages in memory is again a black box for many SQL Server DBA’s. Configuration choice to enable lock pages in memory depends on various aspects. Before we get in to internals we will recollect some of the basics of SQL Server lock pages in memory in 64-Bit SQL Servers. What is Locked pages in … Continue reading SQL Server lock pages in memory