This video demonstrates how to measure and understand the performance of packages, based on lessons learned from enterprise customers. In this video, you will learn the following guidelines for improving performance:
-
How the limits of the source system affect performance.
-
Why disk I/O is important.
-
Why you should establish a package performance baseline.
Thank you to Thomas Kejser for contributing to the material for the series, SSIS: Designing and Tuning for Performance SQL Server Video Series. This video is the first one in the series.
Thank you to Carla Sabotta and Douglas Laudenschlager for their guidance and valuable feedback.
Other Resources
SQLCAT Team
ETL World Record
Help and Information
Getting SQL Server 2008 Assistance