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 - 2007-02-06 : 08:58:13
|
| vighnahar writes "I am using SQL server 2000 / 2005If I run any query on SQL server it is using some memory for it’s execution but not releasing it’s memory after completion on SQL query. This is giving a problem in my application. Where for each user it is consuming 400 MB RAM on SQL server. after login of fifteen users server is getting slow.Is there any way by which I can release memory of SQL server as I don’t want SQL server to keep it’s result etc in memory, So that I can use this memory for other processing.I am writing sample code of VB6 to check for memory utilization. After clicking on button you can observer memory in task manager.Private Sub Command1_Click() Dim con As ADODB.Connection Dim sSql As String Dim Rs As New ADODB.Recordset Set con = New ADODB.Connection con.Open "Upcrest", "sa", "" Rs.Open " select * from sientity ", con MsgBox Rs.Source Rs.Close Set Rs = Nothing con.Close Set con = NothingEnd Sub" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-06 : 10:05:15
|
| Check sysprocesses to see if the connection is really being dropped.SQL Server won't release the memory unless it thinks it needs to. When you say the server is getting slow to you mean sql server? If not then restrict the memory available to it. It doesn't know that other things might need the memory so will assume it can gobble to it's hearts content.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
memory releasing problem