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 - 2005-02-04 : 08:24:42
|
| Rohan writes "Hi Experts,We have a batch program that runs for about 20000 records. Everytime we run this batch program the SQL server memory goes as high as 1GB and stays there even if the program has completed execution. We checked the connections on all dbase they seem to be fine.the name of the service is sqlservr.exe ..the batch program is written in ASP. It is connecting to server using ADODB objects via ODBC Can you please help me knowing what problem is.The -ron" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-04 : 08:26:40
|
| There is no problem. SQL Server does not release the memory it uses unless Windows determines it is out of memory...only then will it make SQL Server release it. This is actually a good thing as it improves performance. The only downside occurs if you are running more than one service on the same server as SQL; IIS perhaps. You should not try to run any other server type on a SQL Server, otherwise each of them will have compromised performance. |
 |
|
|
|
|
|
SQL Server Memory Issue