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 |
|
hans_maddy
Starting Member
1 Post |
 Posted - 2010-12-19 : 12:43:52
|
| Hi Team,We have an ETL process running in which,around 3 million records will be Transformed and loaded in to respective tables for BO purpose.A week back,this process was consuming 3 hours to complete the task.But since a week,the time frame has increase to 5 hours.I am really not able to find the bottleneck !I would like to know the possibilities of improving this issue.Looking forward,Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-12-19 : 13:58:52
|
Check your fragmentation level of indexes.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
|
|
|
ETL Process time efficiency Decreased