Standard SQL 2000 Edition memory limit

[andreis]

Hi:
We receive Sort Warning from SQL Server Profiler and assume we have to increase our SQL Sever 2000, Standard Edition memory capability. The limitation is 2GB, but some people say it’s actually just an OS limitation. If we install, say, Windows Server 2003, would our Standard Edition be able to grab more than 2 GB of memory? Or we still need to open company’s wallet for Enterprise Edition?
Thanks.
Andrei

 

[JayKusch]

You would be able to use 4GB of memory. Here is a link w/ some info that may be useful.

http://www.microsoft.com/windowsserver2003/evaluation/overview/standard.mspx

Thanks

J. Kusch

 

[sunny456]

Jay, I have the same question as Andrei. I checked out your link but couldn't find anything specific to SQL Server. Could you point me to your source of information on this topic. If Windows Server 2003 can indeed allow SS2000 SE to use 4GB of memory it would give us justification for an immediate upgrade.

Thanks in advance,

Sunny

 

[SQLBill]

This Microsoft web page implies that it's only 2GB. Under Standard Edition they list Win2003 as an OS and scalability as UP TO 2GB.

http://www.microsoft.com/sql/evaluation/overview/default.asp

-SQLBill

 

[JayKusch]

Sorry for the mis-info. I pulled the info on W2K Server and NOT on SQL Server. Here is another link w/ some info that may be helpful. AND YES ... You would have to go w/ SS2K Ent. Ed. or better.

http://www.sql-server-performance.com/awe_memory.asp

Thanks

J. Kusch