FIX: An AWE system uses more memory for sorting or for hashing than a non-AWE system in SQL Server 2000

The memory that SQL Server uses during sorting and hashing operations is allocated from the buffer pool as a stolen buffer. Stolen buffers must always remain in the virtual address space. They cannot be unmapped to a Microsoft Windows 2000 Address Windowing Extensions (AWE) location. SQL Server uses

Read More - Register for Free Membership