ta.bu.shi.da.yu (10/15/2009)
All the Microsoft links point to info about the 64-bit versions of Windows. Is this feature restricted to this platform?
The problem only affects 64-bit Standard Edition.
In 32-bit Standard Edition, we could grant 'lock pages in memory' and enable AWE to lock buffer pool pages.
In 64-bit Standard Edition, prior to SP3 CU4 (2005) or SP1 CU2 (2008), there was no way to achieve the same effect.
This was a shocking omission by Microsoft - it is a shame it has taken them so long to correct it. Using a trace flag to enable it seems overly conservative: a trace flag to disable it would seem more sensible, but never mind.
Not sure why anyone should regard this as more useful or necessary on 64-bit systems (which tend to have more memory, if anything) compared to 32-bit systems, but hey.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi