O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 22. Troubleshooting SSIS Performance Issues

Performance Profiling

When working with SSIS, there are different performance-related questions that you might have to deal with, such as the following:

  • SSIS package that is taking longer than usual to complete execution Usually, the normal execution time for an SSIS package that is performing the loading of a fact table is approximately one hour. The SSIS package, which has been scheduled for nightly execution, has been running well for the past six months. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required