We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Should I enable AWE?

Medium Priority
464 Views
Last Modified: 2012-05-06
Hi,

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?

Thanks!
Comment
Watch Question

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

x86; Yes
x64; No.

Author

Commented:

I'm running X86.

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


SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
DBAduck - Ben MillerSQL Server Architect
CERTIFIED EXPERT
Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.