Export (0) Print
Expand All

Enabling Memory Support for Over 4 GB of Physical Memory

To enable Address Windowing Extensions (AWE) for Microsoft SQL Server, you must run the SQL Server Database Engine under a Microsoft Windows account that has been assigned the Lock Pages in Memory option and use sp_configure to set the awe enabled option to 1.

NoteNote

Support for AWE is available only in the SQL Server Enterprise, Standard, and Developer editions and only applies to 32-bit operating systems. Analysis Services cannot take advantage of AWE mapped memory. If the available physical memory is less than the user mode virtual address space, AWE cannot be enabled.

This policy determines which accounts can use a process to keep data in physical memory, preventing the system from paging the data to virtual memory on disk. The Lock Pages in Memory option is set to OFF by default in SQL Server. If you have system administrator permissions, you can enable the option manually by using the Windows Group Policy tool (gpedit.msc) and assign this permission to the account that SQL Server is running.

For more information about how to enable the Lock Pages in Memory option, seeHow to: Enable the Lock Pages in Memory Option (Windows).

Although it is not required, we recommend locking pages in memory when using 64-bit operating systems. For 32-bit operating systems, Lock pages in memory permission must be granted before AWE is configured for SQL Server.

To enable AWE for an instance of SQL Server, use sp_configure to set the awe enabled option to 1, and then restart SQL Server. Because AWE is enabled during SQL Server startup and lasts until SQL Server shutdown, SQL Server will notify users when awe enabled is in use by sending an "Address Windowing Extensions enabled" message to the SQL Server error log. For more information about the awe enabled configuration option, see awe enabled Option.

NoteNote

The information in this section is applicable only if your operating system is either Windows Server 2003 or Windows XP.

To optimize system memory use for SQL Server, you should limit the amount of memory that is used by the system for file caching. To limit the file system cache, make sure that Maximize data throughput for file sharing is not selected.

To check the current setting on your operating system

  1. In Control Panel, double-click Network Connections, and then double-click Local Area Connection.

  2. On the General tab, click Properties, select File and Printer Sharing Microsoft Networks, and then click Properties.

  3. Select Maximize data throughput for network applications, click OK, and then close the rest of the dialog boxes.

For more information about using AWE, see the Windows documentation.

Community Additions

ADD
Show:
© 2014 Microsoft