Should I enable AWE?

Posted on 2009-02-17
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

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

    x86; Yes
    x64; No.

    Author Comment


    I'm running X86.

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

    LVL 57

    Accepted Solution

    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 24

    Assisted Solution

    by:DBAduck - Ben Miller
    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now