April 26, 2006 at 9:23 am
Hi, we have four production db servers with sql server 2000 standard edition on windows 2003 enterprise edition. Two of the servers have a total memory of 4GB and the other two have 12GB total memory. Right now, all sql server instances on these four servers are using only up to 2GB of memory. Is there a way for the first two to use 3GB momory and the other two to use up to 11GB? Because my understanding is the OS wont use that much of memory since they are dedicated Sql server machines. But AWE option is only available for enterprise and devloper editions. Is there a way?
Thanks for any help.
April 26, 2006 at 9:46 am
Kathleen
SQL Server 2000 Standard Edition can only use up to 2GB of RAM. If you want to use more, I'm afraid you'll need Enterprise Edition.
John
April 26, 2006 at 9:52 am
Thanks John. Does turning on PAE switch help at all?
April 26, 2006 at 10:00 am
Kathleen
PAE allows your 32-bit processor to access more than the 4GB of address space it would normally be able to see. However, SQL Standard Edition can still only use up to 2GB of whatever memory is available.
John
April 27, 2006 at 6:17 am
Use the /3GB switch in Boot.ini, and you will at least be able to use up to 3Gb with standard edition.
-tokyoturnip-
April 27, 2006 at 7:04 am
Ron
Since Kathleen has Windows Server 2003, it is true that she can use the /3GB switch in her boot.ini file. This will allow certain applications to access 3GB of RAM instead of 2GB. However, SQL Server Standard Edition can still only use 2GB, no matter what.
John
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply