Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a server running Windows 2003 Enterprise (x86) and SQL Server 2005 Enterprise SP.

The sqlserver process currently consumes aorund 1.6GB of memory although there is around 12GB in the sever (the OS only see's 4GB due to 32 bit limitation). To use all this memory will I need to upgrade to a 64bit OS and 64bit SQL Server enterprise?

I have aslo read about using AWE but would like do it do it without that if possible.

share|improve this question
up vote 3 down vote accepted

32-bit x86 without AWE can only use 4GB of memory. You have to either upgrade to 64-bit or enable AWE to be able to utilize all memory.

share|improve this answer
And you'll need to upgrade both OS and SQL Server. – jishi Mar 7 '10 at 20:53

Without AWE SQL Server is limited to slighly under 2GB of RAM (3GB if you boot with this setting). Using the extra memory requires that you either use AWE or a 64-bit install.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.