August 10, 2005 at 12:56 pm
I am getting ready to install Enterprise Edition SQL Server 2000 on a new server that has 4 processors and 8 GB of RAM. In the past I have installed Standard Edition on this type of box and used the AWE and other switches to get maximum memory usage.
I was wondering if I have to do anything extra to utilize the extra memory when using EE?
Thanks,
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 10, 2005 at 1:07 pm
You need
1. Set /3Gb /PAE switches on boot.ini
2. enable AWE on SQL Server
"When awe enabled is set to 1, AWE memory is used, and the instance can access up to 8 GB of physical memory on Windows 2000 Advanced Server hen awe enabled is set to 1, AWE memory is used, and the instance can access up to 8 GB of physical memory on Windows 2000 Advanced Server "
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_6b3k.asp
August 10, 2005 at 1:20 pm
If you plan to install SQL Server 2000 SP4, don't forget to install the hotfix that addresses the AWE issue. See KB article 899761.
August 10, 2005 at 1:23 pm
Sorry guys, two things. One, the server I did this on earlier was also EE. Extra memory cannot be used with Standard Edition.
Also, I won't be applying SP4 yet.
Thanks,
hawg
----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011
August 11, 2005 at 12:34 am
Just to point it out: You do not need the /3GB switch. With an 8GB RAM dedicated SQL box you normally want to use it, but it is not a requirement. It depends on what kind of work you operating system is doing, but normally Windows will do fine with 1GB RAM.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply