AWE, /3gb and /pae stuff

Hi all,

I'm running under Windows Server 2000 datacenter sp4 with sql server 2000 Sp4

on 16GB Ram.

I enabled the /PAE in the boot.ini file and also enabled the AWE and set the SLQ Server maximum memory to 6144.

Do I need to include the /3GB switch in the boot.ini file?

I'm a little bit confused with the article found on the site. http://support.microsoft.com/default.aspx/kb/274750

Here are the lines.

Use of the /PAE switch in the Boot.ini and the AWE enable option in SQL Server allows SQL Server 2000 to utilize more than 4 GB memory. Without the /PAE switch SQL Server can only utilize up to 3 GB of memory. or-Use of the /3GB switch in the Boot.ini file allows SQL Server 2000 to use up to 3 GB of available memory.

Regards,

Larry

Hi Larry,

As you're running 16GB of RAM, you need to include the /PAE and /3GB switch in boot.ini.

Have a look at http://www.microsoft.com/whdc/system/platform/server/PAE/pae_os.mspx and http://www.sql-server-performance.com/awe_memory.asp

Cheers,

Rob

|||

The /3GB switch allows SQL Server to use an additional 1GB for the database engine purposes -procedure caches, various internal caching needs, etc.

The PAE memory (above 2GB that is not accessed by the /3GB) is used ONLY for data caching.

You most likely want both.

|||

But carefully watch your memory usage when you use 3GB, if misused it might cause system instability because of kernel memory starvation.

Check out the link here with more information about these subjects.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com