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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2007-11-21 : 12:34:14
|
| Everyday in the night we have DTS packages running importing the data from MAS90 SOA files to the SQL Server DB, that DB is over 50GB, initially we drop the tables and recreate them and then transfer the data from the SOA files to the respective DB tables. This process is very unreliable and the execution time varies sometimes it takes about 8 hrs and sometimes it takes about 25 hrs. Just wondering if there's anything I can do to maintain the server before the DTS packages start running as the data is getting deleted everyday and we are not doing any kind of maintenance except backup's of db and logs. Any help is appreciated as I am trying to resolve the issue. Thanks. Please let me know if you need more details. |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-11-21 : 12:37:26
|
| I would check the size of all files in advance, to guarantee that there is no autogrowth during the import. |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-21 : 13:29:45
|
quote:
Originally posted by evilDBA
I would check the size of all files in advance, to guarantee that there is no autogrowth during the import.
I checked the database properties, for the data and transaction log, file properties: automatically grow file is checked.Not sure if this is what you meant. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 17:34:51
|
| Do you load same amount of data every day? Checked resource usages on the server during data loading? |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2007-11-22 : 22:38:04
|
| The data varies every day, but not much variation. Since we drop the tables before loading the data, shall I clear the temp db every day before running the DTS packages. Does this make any difference? Thx. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 22:48:52
|
| Tempdb shouldn't affect that. How much data are we talking about? Does table have index? Did you check resource usages on the server? |
|
|
|
|
|
|
Database maintenance question