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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-06 : 07:27:19
|
| Sreenivas reddy Bora writes "Hi All,We find that SQL Server (Sqlservr.exe) not releasing the Used Memory. We have tested this issue with a small application, which will return few no.of records into to ADO recordset. Once the records fetching completed then the application automatically terminating from Task manager. (Note: Before terminating the application we have closed all the database connections/recordsets and destroying Ado connection, recordset objects.)We have noted from task manager, At the initial stage SqlServr.exe is using 5MB MemoryAfter running the application it is increased to 50MB used memory.After termination of Application, SQL Server not released Used Memory (50MB - 5MB = 45MB). Once we stopped the SQlServer service and restarted then it is coming to Initial stage (5MB).Can you sugget me How can we release the SQL Server Used memory ??? Is there any TSQl commands to release the memory without stopping and restarting the SQL Server Service ???. Because there are N no. of clients will connect to my database. If so, please mail me in detail.Awaiting for Reply.RegardsSreenivas Reddy" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-06 : 07:33:26
|
| SQL Server is designed to use RAM.. it is faster than disk access.If you are running a database server you expect people to be able to use, put as much RAM as you can afford into it.Damian |
 |
|
|
|
|
|
Why SQL Server not releasing Memory ????