Max memory with AWE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Max memory with AWE

Author

Topic

darrenstewart
Starting Member

11 Posts

Posted - 2010-08-09 : 06:04:45

Hi all,

We are currently running Windows Server 2003 Standard Edition with SQL 2005 Standard Edition, the server has 4Gb RAM.

I know there are limitations to the amount of RAM server 2003 can utilise (4Gb I believe), however I have been told that through enabling AWE in SQL we could increase the amount of memory SQL can use.

Can anyone confirm whether if I put say 16Gb RAM in the server and enable AWE, SQL will be able to use this RAM?

EDIT: Also note that we are using the 3GB switch at the moment.

Thanks very much
Darren

mandm
Posting Yak Master

120 Posts

Posted - 2010-08-09 : 17:27:31

Check out the link below. It gives all the steps needed to set this up.

http://technet.microsoft.com/en-us/library/ms190731.aspx

In looking at this further your OS being standard edition may prevent you from adding more than 4 gig to the server.

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2010-08-09 : 22:18:44

If the OS cannot see the memory, neither will SQL Server. To get the best usage, you should upgrade to x64 and forget about using AWE at all.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources