July 7, 2003 at 6:38 am
Hi!
Just increased the RAM on server (W2k+sp3 & MS SQL 2000+sp3) from 2Gb to 4Gb
The sp_configure for max server memory shows:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
max server memory (MB) 4 2147483647 3792 3792
The Task Manager for sqlserv.exe process shows ~1759988Kb and does not grow.
The server has ~15 user databases some are 7-17Gb.
Why it does not use so much free memory (~1784Mb)?
July 7, 2003 at 7:22 am
Did you add the 3G switch in the boot.ini? Once you set that and reboot you should see the memory that SQL Server allocates increase.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 7, 2003 at 7:23 am
SQL Server Standard Edition only supports up to 2GB RAM per instance. SQL Enterprise edition can use more, but you must configure advanced options (or possibly AWE if >= 4GB RAM) see Books OnLine for more info on higher RAM configurations. If you are on SQL 2000 Standard edition, you can check out this FAQ on running multiple instances of Standard Edition to take advantage of greater than 2GB RAM (there are pluses and minuses...)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply