help on memory config??

Question

help on memory config??

Jp

Default port

Points: 1419
More actions
February 13, 2006 at 8:43 am

#113392

hi,
i have a box with windows 2000 server with sp4 ,sql2k Enterprise with sp3a and the box has 4GB Physical RAM.Can I take advantage AWE or PAE??
Any Help??
Thanks.
--jp

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

John Rowan SSC Guru Points: 56440 More actions · Answer 1

AWE and /PAE allow you to take advantage of memory above 4GB. By default, SQL Server will consume 2GB of the base 4 and leave the other 2GB for the OS and other applications/processes. You can use the 3GB switch in your boot.ini file to allow SQL Server to have access to 3GB, leaving 1GB for the OS and other non-SQL Server processes.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Jp Default port Points: 1419 More actions · Answer 2

Thanks Johnrowan.

Is it possible on WINDOWS 2000 SERVER edition + sql enterprise???

John Rowan SSC Guru Points: 56440 More actions · Answer 3

It should be....http://support.microsoft.com/kb/833722/en-us

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Jp Default port Points: 1419 More actions · Answer 4

Below is the excerpt from beow MS article and it conflicts with what the article you said.

http://support.microsoft.com/?scid=kb;en-us;274750&spid=2852&sid=global.

Support for operating system versions

Windows 2000 Server

SQL Server 2000

Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition can use up to 2 GB of physical memory. With the use of the AWE enable option, SQL Server can use up to 4 GB of physical memory.

Note You cannot allocate more than 4 GB of physical memory to an application on Windows 2000 Server because Physical Address Extension (PAE) is not available on Microsoft Windows 2000 Server. Also, you cannot use the 3 GB switch in the Boot.ini file with Windows 2000 Server; however, you can use the 3 GB switch in the Boot.ini file with Microsoft Windows 2000 Advanced Server or Microsoft Windows Datacenter versions. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

291988 (http://support.microsoft.com/kb/291988/) A description of the 4 GB RAM Tuning feature and the Physical Address Extension switch .

John Rowan SSC Guru Points: 56440 More actions · Answer 5

Judging from the article in your post, you cannot take advantage of the 3GB switch if you are only running Windows Server 2000 standard edition.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Vik Nat Hall of Fame Points: 3930 More actions · Answer 6

Correct - you have to have Windows Adv server/SQL ENT to be able to use Mem above 2GB.

Jp Default port Points: 1419 More actions · Answer 7

Jp

Default port

Points: 1419

February 14, 2006 at 12:01 pm

#620800

Thanks Guys.!!