Friday, March 9, 2012

Memory release

I am using SQL Server 2000 SE. When I used my application, the SQL server memory go on increasing & it will never come down. Application runs very slowly. Can anybody suggest how to release memory from sql server.

Thanks in advance.
SQL Server will release memory when something else on the machine requires the memory. If it is allocating more memory, then the SQL Server needs that memory to process requests. Just because the application is "running slowly" doesn't mean it is caused by SQL Server memory utilization.|||

Hi Michael, thank you very much.

I'm a SQL new programmer. I want to ask more.

Suppose some users use my application concurrently. They run different reports and these reports use almost server memory. I saw this in server. After that these users close reports. I watch memory in server, it isn't released. If new report runs, in this case SQL sever/OS will automatically reallocate memory for new task-report. SQL server/OS work this way, isn't it?

Thanks.

No comments:

Post a Comment