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.
| Author |
Topic |
|
jim_cool
Starting Member
43 Posts |
 Posted - 2007-01-03 : 01:05:52
|
| 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:34:46
|
| From where are you executing the SP? Front-end or SSMS?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2007-01-03 : 02:00:30
|
| I am executing query from SSMS.My .Net Application is also accessing same server for querying the database. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-03 : 11:36:26
|
| this is by design. mssql will grab all the memory it can. check memory tab in ssms. this article will explain a bithttp://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=6 |
|
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2007-01-03 : 23:43:23
|
| Thanks for your reply.The link that u specified in ur reply was really helpful. |
|
|
|
jim_cool
Starting Member
43 Posts |
Posted - 2007-01-05 : 07:25:01
|
| Plz suggest me the solution by which SQL Server will free the memory after its has finished executing some task. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-01-05 : 13:13:57
|
| if this is on a dedicated server, you dont want to free up the memory. what else is running on the box? in any event stopping sqlserver.exe in services applet ought to do it...but cant think of y u want to... |
|
|
|
|
|
|
Incremental Excessive Memory Usage