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 |
|
samtoffa
Yak Posting Veteran
60 Posts |
 Posted - 2004-08-03 : 06:06:59
|
| When I run DTS packages (just simple table export to other databases etc) server memory is steadily used up by the processes but is not freed afterwards. The only way I can free the memory is to stop and re-start the server.In the memory configuration I have set the amount of memory available to SQL server to a FIXED size, but this is being exceeded when I transfer data from one server to another. Is this possible?!! Do I need the same memory allocation on both servers? Do my problems lie in the operating system rather than SQL server?Any help appreciated,Sam |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-08-03 : 08:16:33
|
| OK 1ST Question WHY the fixed memory Size?Why not set the max and min and let SQL do its Job?JimUsers <> Logic |
 |
|
|
samtoffa
Yak Posting Veteran
60 Posts |
Posted - 2004-08-03 : 11:25:13
|
| Hi Jim,The Fixed memory size was my attempt to sort out the problem....it didn't work! Usually I just sit back and allow memory to be dynamically allocated by SQL but these data transformations have been EATING memory. I sent a copy of a table (2.5 million rows) to another machine and used the performance monitor in Windows task manager to watch the system memory allocated to SQL go from 15MB to almost 1GB !! Is SQL trying to load the WHOLE table into memory?Sam |
|
|
|
|
|
|
Server Memory Problem