Windows 2003 Std with SQL 2008 can I use AWE

Posted on 2011-10-18
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
    LVL 8

    Accepted Solution

    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

    LVL 8

    Expert Comment

    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

    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.
    LVL 1

    Author Comment

    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

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    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…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    733 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

    19 Experts available now in Live!

    Get 1:1 Help Now