• 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.