Should I enable AWE?

Posted on 2009-02-17
Medium Priority
Last Modified: 2012-05-06

I have the following set up:

* Intel Xeon 3.6GHz
* 6G RAM
* Win 2003 Server R2
* SQL Server 2005 Standard

I have 2 applications (Microsoft Operations Manager and Blackberry Mobile Admin) on the same server. The MOM app is I/O intensive.

Question: Should I even bother enabling AWE? And if yes, how should  allocate the memory portions?

Question by:TheGoofyOne
LVL 13

Expert Comment

ID: 23661573
You need to say if you're running x86/x64.

x86; Yes
x64; No.

Author Comment

ID: 23661609

I'm running X86.

What is the min/max memory should I set for SQL Server?

LVL 57

Accepted Solution

Raja Jegan R earned 1200 total points
ID: 23661827
I suggest you can use 3GB of AWE memory for your SQL Server.

Some basic considerations;

1. One caution about using the "awe enabled" setting is that after turning it on, SQL Server no longer dynamically manages memory. Instead, it takes all of the available RAM (except about 128MB which is left for the operating system).
2. If you want to prevent SQL Server from taking all of the RAM, you must set the "max server memory" option
3. If you allocate the memory for AWE, your server takes it completely, and you wont be able to use that memory for other applications on that server.
LVL 25

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 300 total points
ID: 23663826
The other thing to remember about AWE is that it will be used ONLY for Data cache and not procedure cache, so you won't necessarily see an increased ability to cache plans, but it is helpful because it will be used for DATA caching for the SQL Engine.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question