May 15, 2006 at 11:30 pm
Hi all,
I understand that in order for SQL Server to use more than 2GB of memory on a server which has more than 2Gb installed we have to enable AWE. Most of the sites I have read discuss only about Windows 2000. Below is a chart showing versions of Windows 2000 and SQL Server 2000 that support AWE memory:
Windows Version | SQL Server 2000 Enterprise Edition | SQL Server 2000 Standard Edition | SQL Server 2000 Personal Edition | SQL Server 2000 Developer's Edition |
Windows 2000 Datacenter Server | 64GB | 2GB | 2GB | 64GB |
Windows 2000 Advanced Server | 8GB | 2GB | 2GB | 8GB |
Windows 2000 Server | 4GB | 2GB | 2GB | 4GB |
Windows 2000 Professional | N.A. | N.A. | 2GB | 2GB |
What I wanted to know was about Windows Server 2003. Do we need to enable AWE for all Editions of Windows Server 2003 also?
Thanks.
Shahid.
May 16, 2006 at 1:47 am
The configuration of AWE within SQL Server shouldn't be confused with the o/s making the memory available. Regardless of o/s you still have to enable awe within sql server. with 2003 the /PAE switch is usually enabled by default.
The amount of memory usable by Enterprise sql server on w2003 ent ed is 32 gb vs 16gb on w2000 adv server
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply