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 |
|
roykauf
Starting Member
36 Posts |
 Posted - 2008-02-27 : 06:03:49
|
| Hi to all,I front a series problem with my SQL Server.I Use SQL Server 2000 standard on Windows 2000 Server machine.The problem: after certain actions such as DTS (that takes table contents and insert to a a file) the Memory usage of SQLservr.exe is grown significantly and after it finshes with success it doesn't free the used memory for the action - in this case the DTS. maybe this explains why I have Memeory Usage of 1700MB of Sqlservr.exe on windows task manager.Is it a bug? why SQL doesn't free the memory after finishing the action.Any Solutions ? Please send me a short feedback.Roy |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-27 : 06:10:54
|
| SQL Server will grab all the memory it thinks it may need in future, if another application requires the memory, it will release it, otherwise it will keep it. This is not a bug. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-27 : 23:26:26
|
| For non-dedicated sql server, you can set max memory for sql to use. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-02-28 : 01:18:12
|
| If at all possible , it is better to have the SQL SErver on a dedicated box - without many other services runningJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQL Memory Usage Problem