July 15, 2009 at 6:34 am
I would like to monitor the performance of individual steps of a package after it is installed and running via SQL Agent. The package has numerous steps and runs with a significantly lower elapsed time when in a test environment than in the production. The process links to several external data sources and on a schedule the is "off hours". I would like to be able to identify which piece (or pieces) of the overall process is the cause of the time difference.
Is there a way to identify the individual steps of a package execution (similar to the job history from SQL Agent). The SQL Agent only provides the total package execution time.
Thanks in advance.
July 15, 2009 at 9:21 am
All you need is the bids helper (free download from codeplex)
http://bidshelper.codeplex.com/Wiki/View.aspx?title=SSIS%20Performance%20Visualization
July 16, 2009 at 11:05 am
Thank You. I will download and check to see if it works for my goal.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply