Export (0) Print
Expand All
Expand Minimize
0 out of 3 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.