April 20, 2010 at 9:46 am
I've created the SSIS package and initially, it used to take 3.5 hours to complete. The package basically builds table and inserts data into the table. However, recently, the entire job completed in less than 2 minute. I've looked at the data and it appears all datas are in place. Any thoughts how/why or where I might want to research to find out?
April 20, 2010 at 10:38 am
The first thing that came to mind is that this might be a scheduled job and that other database maintenance tasks like re-orgs/re-indexes may have been conflicting either directly with your process or by tying up the disk sub-system.
What changes have been applied to the system recently?
CEWII
April 20, 2010 at 12:09 pm
Most questions in these forums are the other way around 😀
Did you change anything in the package? For example, set the OLE DB Destination to fast load or something like that?
Or did your DBA decided to put some indexes on your tables? Indexing can really speed things up. Today I speeded up a package from 20 minutes to 2 minutes just by changing some indexes from non-clustered to clustered.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply