[dba-SQLServer] Lock Pages in Memory

jwcolby jwcolby at colbyconsulting.com
Wed Nov 4 10:55:01 CST 2009

I ran across this today.


It mentions in passing the "lock pages in memory" setting.


Apparently SQL Server can swap some fairly critical SQL Server pages to disk at inopportune times 
and this setting prevents that.  It was only available on the Enterprise edition but apparently MS 
relented and made it available to the masses (standard version as well).

I truly have no clue (as you guys know) ;) but we shall see whether that helps me at all.

John W. Colby

More information about the dba-SQLServer mailing list