Hi All,

I am using SQL Server 2000. But when I used my application, the SQL server memory go on increasing & it will never come down.I can see this in task manager. Can anybody suggest how to release memory from sql server.

Thanks in advance.

Ajay

releasing memory is a managed process and it will be called as and when required. Lots of memory will be consumed while SQL Server is running some heavy process which will be reduced after some time. May not be immedeatly after the process is completed.

Regards
Ganesh

if you are using ado, make sure that you do a connection.Close() each time. Otherwise, the connections will automatically be closed by SQL Server as and when required. Aso check the SQL Error log

Regards
Ganesh

Hi Ganesh,

Thanx a lot for the info.

I have asp.net web application with sql server. I am using sqlconnection object for making the connections and I am closing those connection objects immediately after using them. I am not getting any error logs from sql server. Can u tell me how & where I can check them.

Thanx.

Ajay