jcosta (8/20/2009)
Jeffrey,On x64 hardware, Microsoft says that the "Lock pages in memory" right is not necessary. From this Technet article:
http://technet.microsoft.com/en-us/library/ms190730.aspx
"Locking pages in memory is not required on 64-bit operating systems."
What makes you recommend it on x64?
Read my post above. Microsoft itself can't make up its mind on this.
Lock Pages also only prevents other apps (like another SQL Server Instance) from taking memory.
The OS can take whatever it wants.
Craig Outcalt