Memory management

I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
server is running around 5 Databases .. we have Pentium IV and RAM 2 GB .
SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce memory consumption as on connection to sql goes down or no one is connected to sql server. SQL Server won't free this ram. we haven't allocated memory for sql server. When we restart the sql server services then the memory consumption goes down to 400 MB.
What may be the cause and what can be done to solve it?Once SQL Server acquires memory, it will retain it unless it is needed by
other applications running on the server. This maximizes performance
because data will remain in cache and memory allocation/deallocation is
costly.
If you routinely run other applications on the same server, consider setting
the max memory for SQL Server,
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Saleem Subhi" <saleemsubhi_mcs98@.yahoo.com> wrote in message
news:D02C548A-58EE-44CA-9D73-9ADFC9970942@.microsoft.com...
> I am running SQL 2000 Enterprise SP 3 with Windows 2000 . Our sql
> server is running around 5 Databases .. we have Pentium IV and RAM 2 GB
.
>
> SQL Server it self takes more than 1.5 GB to 1.6 GB RAM .. it won't reduce
memory consumption as on connection to sql goes down or no one is connected
to sql server. SQL Server won't free this ram. we haven't allocated memory
for sql server. When we restart the sql server services then the memory
consumption goes down to 400 MB.
> What may be the cause and what can be done to solve it?