Memory usage increasing

Hi,
I open one of the modules in my program and then close
it. I did not end the program. The memory usage in the
SQL server does not decrease or remove from it. I check
it from the Process Info at the Management folder in the
database. How to release the memory from the SQL server?
Is it the programming method that I am using or this
behaviour is normal?
Please help. ThanksIf you are referring to the database server, this behaviour is normal. SQL
Server will try to claim all system memory for itself, less ~5 MB, upon
startup. It works more efficiently that way, hence the often repeated
advice that you should try to use a dedicated database sever. Thus, you
might have 100 connections and close all of them, but the memory used by SQL
Server will not decrease.
If you want to, you can limit the min. and max. amount of memory SQL Server
can use from Enterprise Manager.
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"carina" <carina_a@.yahoo.com> wrote in message
news:19fd501c44ddd$038649a0$a501280a@.phx
.gbl...
> Hi,
> I open one of the modules in my program and then close
> it. I did not end the program. The memory usage in the
> SQL server does not decrease or remove from it. I check
> it from the Process Info at the Management folder in the
> database. How to release the memory from the SQL server?
> Is it the programming method that I am using or this
> behaviour is normal?
> Please help. Thanks