Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Configure the awe enabled Option (SQL Server Management Studio)

In SQL Server 2005, you can use Address Windowing Extensions (AWE) to provide access to physical memory in excess of the limits set on configured virtual memory.

If the option has been enabled, the message "Address Windowing Extensions enabled" is written to the SQL Server error log when the instance of SQL Server 2005 is started.

Before you use AWE, you must first configure the Microsoft Windows Lock Pages in Memory policy. For more information, see How to: Enable the Lock Pages in Memory Option (Windows).

To support more than 4 GB of physical memory on 32-bit operating systems, you must add the /pae parameter to the boot.ini file and reboot the computer. See your Windows documentation for details.

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Memory node.

  3. Under Server memory options, select Use AWE to allocate memory.

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

Community Additions

© 2015 Microsoft