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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-01-25 : 02:25:09
|
| hi, in the weekend i see that the DTS take 25 hours (it is not normal) cause before some months it take couple of hours.i see in the some steps that use with TEMP,take the long of time.(couple hours)how can i check that problem?i dont know how to check the TEMP.EXAMPLE:BEFORE 2 MONTH (base on mu memory)DTS:Build FactSTEP 1: 2 MinSTEP2: 1/2 hours (use temp,build table and insert data)STEP 3: 4 MinSTEP 3 1 Hours (use temp,update)TODAY:DTS:Build FactSTEP 1: 2 MinSTEP2: 4 Hours (use temp,build table and insert data)STEP 3 7 Hours (use temp,update)thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 04:54:54
|
| temp? you mean temporary table? how are you creating and updating it? some background info of dts package will help |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-01-25 : 05:06:05
|
quote:
Originally posted by visakh16
temp? you mean temporary table? how are you creating and updating it? some background info of dts package will help
sorry i think that i mistake , we build regular tables and delete it by drop.like: CREATE TABLE [UNION_FACT_TEMP] in another step i write select * into temp_calci must to say before 2 month every think was work fine but recentaly we have problems. the dts build the fact ,it is very complicated and to described it ,is more .where can i start to check it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 05:08:03
|
| select into can be bit slow when compared to insert.. select. why not create it earlier and try using insert...select instead |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 05:08:58
|
| also. is your table statistics updated? and do you have reqd indexes on tables? |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-01-25 : 05:13:29
|
| ok,first i cant change the dts it work for years, and this stpe take long time but the next step that update the couple hourse (this query used with tables in previous steps)i thinks that something get disrupted behind the tables,what do you thinks? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-25 : 05:26:43
|
| then you may better off looking into indexes and statistics of table and create/update them |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-01-25 : 07:49:16
|
| we dont have indexes |
|
|
|
|
|
|
|
|
DTS Running so long of time