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

Does SQL Server 2008 Web Edition support AWE?

share|improve this question

Yep, however AWE is used in an x86 environment. If you use an x64 environment you won't need it as SQL will automatically have access to all the available memory.

share|improve this answer
It is a x86 server. I set 'Lock pages in Memory', enabled AWE and set the 3GB switch (which is a bit different in Windows 2008 as there is no boot.ini) and performance seemed to degrade. Maybe this is because I have exactly 4GB RAM installed and wasn't sure whether to use AWE anyway. What do you think? – Pat Jan 22 '10 at 11:29
Lock Pages won't do anything on Web Edition. By default it only works on Enterprise Edition, and it is available via a trace flag for the Standard Edition. As far as I know it doesn't do anything on the Web or Workgroup editions. Even if it did, with only 4 Gigs of RAM installed you don't want to stop the OS from managing the memory. How much memory are you allowing SQL to use. Unless it is over 2 Gigs the 3GB switch and AWE won't do anything for you. – mrdenny Jan 23 '10 at 6:42

I believe so, it is stated that is supports RAM up to the OS max, it would need AWE to access it.

share|improve this answer
So why the degredation in performance after AWE was enabled? – Pat Jan 22 '10 at 12:31
Is the server dedicated to SQL, or running other apps/services as well? What is maximum memory set to in SQL? – SqlACID Jan 23 '10 at 4:37

Microsoft will remove AWE support next version of SQL Server. Because new OS already 64 bit systems and addressing much more RAM sizes

share|improve this answer

Your Answer


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