ETL Process time efficiency Decrease

• abendigeri

  SSC-Addicted

  Points: 433

  More actions

  December 19, 2010 at 10:19 am

  #229718

  Hi Team sqlservercentral,

  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

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  December 19, 2010 at 11:13 am

  #1264451

  duplicate post, answers to

  http://www.sqlservercentral.com/Forums/Topic1036985-148-1.aspx

  please

  ---------------------------------------------------------------------