Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Reclaiming RAM used by SQL Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-12 : 10:46:02
Michael writes "Using the performance monitor on SQL Server 2000, I notice that any query will boost the amount of RAM used. After the query is done, however, the RAM isn't released for further use. When a second query starts, it keeps grabbing more RAM starting where the first query left off. This continues unless I reboot the server.

How can I reclaim the RAM (i.e., make it available for applications) without rebooting the server?

Thanks for your advice."
   

- Advertisement -