[dba-SQLServer] Lock Pages in Memory

I ran across this today.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

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

http://support.microsoft.com/kb/918483

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
www.ColbyConsulting.com