Memory usage on SQL Server over 2 GB

Our SQL Server was using almost all 2GB of available RAM on the machine, so
we upgraded RAM to 3GB. Since then I've noticed it's still using almost
exactly 2GB. I'm guessing this means there is some limitation on how much
memory SQL Server will make use of. Is there some switch that allows SQL to
make use of the additional memory ?
SQL Server 2000 on Windows 2000 (both standard editions)Hi
SQL Server 2000 Standard edition will only allow a maximum of 2GB RAM. So the rest 1 GB will be used for all the other application including OS
SQL Server Enterprise will support 4 GB RAM
Thank
Har
MCDB
-- Richard wrote: --
Our SQL Server was using almost all 2GB of available RAM on the machine, s
we upgraded RAM to 3GB. Since then I've noticed it's still using almos
exactly 2GB. I'm guessing this means there is some limitation on how muc
memory SQL Server will make use of. Is there some switch that allows SQL t
make use of the additional memory
SQL Server 2000 on Windows 2000 (both standard editions