SQL Server Performance

ETL Process time efficiency Decreased

Discussion in 'SQL Server 2005 Integration Services' started by hans_maddy, Dec 19, 2010.

  1. hans_maddy New Member

    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
    hans_maddy, Dec 19, 2010
    #2

  2. Adriaan New Member

    Adriaan, Dec 19, 2010
    #3

  3. satya Moderator

    Welcome to the forums.
    As you say it is a huge process to process the millions of records it would help if you can also specify the underlying hardware, processes that are running when this job is executed. Also the database maintenance practices on thsi database. THe underlying disk would help to speed up the performance to some extent and also the TSQL used in this import process. So if you can shell out these details we can help out more in detail.
    satya, Dec 21, 2010
    #4

Share This Page