0

Does SQL Server 2008 Web Edition support AWE?

Improve this question

3 Answers 3

Reset to default
1

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.

Improve this answer
2
  • 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? Commented Jan 22, 2010 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. Commented Jan 23, 2010 at 6:42
0

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

Improve this answer
2
  • So why the degredation in performance after AWE was enabled? Commented Jan 22, 2010 at 12:31
  • Is the server dedicated to SQL, or running other apps/services as well? What is maximum memory set to in SQL? Commented Jan 23, 2010 at 4:37
0

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

Improve this answer

You must log in to answer this question.