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 - 2002-06-13 : 08:09:50
|
| Gaurav writes "I am using SQL Server 7.0 on Windows 2000 Advanced Server. After running DTS Packge written in VB Script, the memory used by the SQL Server goes very high and does not come down even after the package has executed successfully. If I run the package again, memory increases again till it reaches the maximum Ram of the server i.e 2 GB and then the server hangs. Is there any way to free the memory taken by SQL server?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-13 : 08:50:43
|
| No. SQL Server will use as much memory as is available, and it will only release under very specific conditions, none of which you can directly control.The most you can do is limit the maximum amount of RAM that SQL Server uses. You can do that in Enterprise Manager; right-click the server, choose Properties, and change the settings on the Memory tab.Unless your SQL Server is running other processes (IIS, Exchange, Domain Controller) there's no harm in letting it glom all of the RAM (SQL Server really should be the only thing that runs on the machine anyway...you'll get performance problems otherwise) |
 |
|
|
|
|
|
Free Memory