Maximum memory usage

Question

Post reply

Maximum memory usage

YuanQiang

Mr or Mrs. 500

Points: 520
More actions
September 17, 2003 at 11:41 pm

#106229

I am confused with the Maximum physical memory usage an instance of SQL2000 Enterprise Edition can take on a Windows DataCentre. Answers from MS support site are different, or I understood wrongly.
These two links show 32GB http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
http://support.microsoft.com/default.aspx?scid=kb;EN-US;268363
while this one shows 64GB
http://support.microsoft.com/default.aspx?scid=kb;en-us;811891
Could anyone advice?
Thanks.

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

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

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Wre are running Windows Datacenter that supports up to 64GB for SQL Server.

YuanQiang Mr or Mrs. 500 Points: 520 More actions · Answer 2

Thanks Allen.

Can I say that if AWE is not enabled, SQL2000 can only take up to 32GB on Datacenter?

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

If AWE is not enabled, SQL Server can use only up to 4GB memory.

YuanQiang Mr or Mrs. 500 Points: 520 More actions · Answer 4

Can this situation be true where you have /PEA switch turned on, but AWE not enabled?

If it can be true, how big RAM SQL2000 can utilise in Maximum?

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

/PAE is used by OS to use memory beyong 4GB and AWE is used by SQL Server to use memory above 4GB. You need both on if you want to use memory more than 4GB.

YuanQiang Mr or Mrs. 500 Points: 520 More actions · Answer 6

YuanQiang

Mr or Mrs. 500

Points: 520

September 22, 2003 at 4:46 pm

#475322

Thanks Allen. It's very clear now.