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 |
|
rtr1900
Starting Member
48 Posts |
 Posted - 2008-05-02 : 03:28:44
|
| Hi,I am importing automatically DBF files (10 of them) into SQl every 20 minutes (with intervals of 2 minutes so they won´t be executed togetehr).Still I am getting a lot of Memuse. In the Taskmanager my SQLSERVER.EX file gets up to 2GB after a couple of days (maybe 1 week). I search the ineternet at I found that it has to do with Sql Server. I have 2003 and it has the latest updates.First I thought it would be a programmingproblem( I posted a previours question about it in the forum), but as we don´t execute the ASP files during the weekend, I noticed that the memory was also getting higher then, so it couldn´t be the ASP files with their lost conections to the server.Does anybody has had a similar problem? And if so, what can I do?Can I for example execute different command to import data one after another in a batch or so, that that the second won´t be execte until the first is done. It is getting annoying the mem problem...any help is very welcome!!!!Thx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 12:48:04
|
| Sql server will use all available memory by default setting, it's normal and nothing to do with loading files. If machine is not dedicated for sql, you can set max memory for sql with sp_configure. |
 |
|
|
|
|
|
Memory Problem DTSRUN