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.
Thanks
Hari
MCDBA
-- Richard wrote: --
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)