Post reply

Installed SSIS Package performance monitoring

  • July 15, 2009 at 6:34 am

    #132055

    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

    #1025159

    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

    #1025795

    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