June 24, 2002 at 1:27 pm
I am running SQL Server 2000 standard edition on a Win 2000 server. I have installed service pack 2 for both Win 2000 and SS 2K.
I have 1G of RAM and 2 drives of 15G and 31G(31 G has the data files).
I noticed that in the past 2 weeks the memory usage as seen in the Win Task Manager is increasing. I had a log from the Performance monitor. The %Committed bytes has gone from 8 to 33 in these 2 weeks. A few new tasks were added.
Currently no tasks are running against the server since around 9am this morning. It is now 3:30pm and the committed bytes has not come down. The mem usage is still at 763,476K for sqlserv.exe. Other than an optimize db at 12 noon and a txn bkup with init at 12:15pm there have been nothing running against the sql server since 9am.
Can anyone please help me understand why the usage is not coming down?
Thanks in advance.
June 24, 2002 at 1:31 pm
SQL Server will not release the memory once it has allocated it because it expects that it will need it again. If you start other tasks on the server that begin requesting memory, SQL Server will start to release memory to NT to achieve a balance.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply