Export (0) Print
Expand All

Managing Memory for Large Databases

SQL Server uses the Address Windowing Extensions (AWE) API to support very large physical memory sizes. SQL Server supports up to a maximum of 64 GB of physical memory on 32-bit Microsoft Windows operating systems: Microsoft Windows XP Professional; Windows 2000 Standard Edition; Windows 2000 Advanced Server; Windows 2000 Datacenter Server; Windows Server 2003, Enterprise Edition; or Windows Server 2003, Datacenter Edition.

SQL Server dynamically allocates AWE mapped memory when running with any of the Windows Server 2003 operating-system editions. In other words, the buffer pool can dynamically manage AWE mapped memory to balance SQL Server memory use with the overall system requirements.

AWE addresses a limitation inherent in 32-bit applications: they cannot access more than 4 gigabytes (GB) of process address space. (A 32-bit pointer cannot hold a memory address larger than 4 GB.)

Using AWE, applications can directly reserve physical memory up to the maximum amount allowed by the operating system as non-paged memory. Using AWE allows SQL Server to cache more information instead of reading it from system paging files on disk. This, in turn, provides for performance gains through faster data access and reduces the frequency of disk access.

NoteNote

64-bit applications do not require AWE because access to memory is not limited to 4 GB.

For more information about the AWE API, go to the MSDN Web site, and search on the term "Address Windowing Extensions."

For information about how SQL Server works with non-uniform memory access (NUMA), see Understanding Non-uniform Memory Access.

Using AWE

Describes considerations for using AWE.

Enabling Memory Support for Over 4 GB of Physical Memory

Describes the process of enabling large amounts of memory on 32-bit operating systems.

Enabling AWE Memory for SQL Server

Describes configuring AWE.

Hot Add Memory

Describes how SQL Server supports hot add memory.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft