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)
 Incremental Excessive Memory Usage

Author  Topic 

jim_cool
Starting Member

43 Posts

Posted - 2007-01-03 : 01:01:14
Hi Group,

I am facing peculiar problem with SQL Server 2005. When I run my Huge Stored Procedures, memory would get increased/allocated (say by 15MB). But that does not get decreased/deallocated after turning off the application or session.

Memory which is used by Sql Server should get released after sometime. Can I fix that timing or can release the excessive memory without restarting SQL Server 2005?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-03 : 01:35:37
Duplicate Post:
[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77017[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page
   

- Advertisement -