How to get SQL to use more RAM

[andshr]

Hi;
We have SQL 2000 Standard Edition running on Windows 2000 Service Pack 4. It doesn’t allow SQL to use all available 4 Gb of RAM, only 2 Gb. Can anyone help to find out which version of Windows 2003 would let SQL to grab 4 Gb of memory?

 

[mrdenny]

Windows 2003 Standard edition will allow SQL to address up to 4 GB of memory provided that you install SQL 2000 Enterprise Edition. SQL 2000 Standard Edition only supports 2 GB of memory.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[andshr]

Thanks a lot, we are looking at this possibility...