April 18, 2003 at 3:08 am
Just a little bit confused on this topic.
Environment:
SQL Server 2000 Enterprise edition.
Windows 2000 Advanced server.
4 GB RAM.
I am thinking to do this actions so I ask you to please advise if you think this is a correct approach:
Add on the BOOT.ini file the /3GB switch alone,not the /PAE switch.
sp_configure 'show advanced option' ,1
reconfigure
go
sp_configure 'awe enabled' ,1
reconfigure
go
sp_configure 'max server memory', 3072 (here I have a little doubt!)
reconfigure
go
so_configure 'min memory', 1024 (here I have a lots of doubts!)
reconfigure
go
reboot server
Thank you for your time.
Kind regards.
Franco
Franco
Franco
April 18, 2003 at 7:01 am
Not sure if this answer your question, but check the article posted by Joseph Sack http://qa.sqlservercentral.com/columnists/jsack/aweadventures.asp
April 21, 2003 at 8:53 am
You need only /3GB in your boot.ini file. Enabling AWE in SQL Server doesn't have any effect because your server has only 4GB memory.
I would let SQL Server to dynamically adjust memory allocation by set "min server memory (MB)" to 0 and "max server memory (MB)" to maximum memory you have.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply