Windows 2003 Std with SQL 2008 can I use AWE

Posted on 2011-10-18
Medium Priority
Last Modified: 2012-05-12
Hi Guys,

I have Windows Server 2003 Std 32-bit with SQL Server 2008 installed.  My system has 6GB of memory installed but only 3.5GB can be accessed by windows.  Can I activate AWE to give more memory to SQL Server?

I've been trawling through the forum looking for someone with a similar setup but can't find it.  I'm beginning to think it can't be done.
Question by:Peter1985
  • 2
  • 2

Accepted Solution

coolfiger earned 2000 total points
ID: 36986545
it depends on your OS. If your os can access the ram then activating AWE would work


If your os cannot access the ram then you cannot access this.  From your topic its sayign you have 2003 STD which means you can only see up to 4 gigs of ram. You need to upgrade to enterprise or 64bit to be able to use this ram

Expert Comment

ID: 36986608
OEEnigma: he is running server 2003 standard so it means sql will only be able to see what the OS sees which is no more than 4 gb

Expert Comment

ID: 36986636
I am aware of that and it was indicated in the doc. I guess I should have been a little more verbose. Thanks for the reminder.

Author Comment

ID: 36986758
Thanks guys I thought that might be the case.  I don't believe there are upgrades available for Windows 2003 anymore.  I'll have to research the upgrade paths.

Thanks again.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

839 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