October 1, 2009 at 12:10 pm
Folks,
Over the past couple of days, one our ETL job that loads data to our ODS database has been running slow. All of a sudden the execution time has doubled from 2 and half hours to 5 and half hours.
The ETL Job has 40 different steps and each of them call a SSIS Package. It used to complete within 2 and half hours until 2 days back. The volume of data that is getting loaded has not changed drastically, we are re-building the indexes daily. What could be going wrong here?
Any ideas or pointers towards troubleshooting?
Thanks in advance!
Amol
Amol Naik
October 1, 2009 at 1:55 pm
Did you notice if one of the tasks is taking long time and all tasks are taking long time in Package.
Second, make sure that index-rebuilding is not running at the time when you are doing any big transactions on sql server. Index Rebuilding is performance intensive task.
I guess these the basic points you need to start with.
Swarndeep
http://talksql.blogspot.com
October 2, 2009 at 11:37 am
Thanks, but there is no re-index job occuring at the time job is running. By the way our ETL job ran quicker today in just 3 hours. There was some kind of Disk IO latency on those 2 days, as per our Infrastructure team and the Data center team.
Amol
Amol Naik
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply