Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video)
Applies to: Microsoft SQL Server Integration Services |
Authors: Denny Lee, Microsoft Corporation |
Length: 00:11:54 Size: 27.5 Mb Type: WMV file |
Watch this Video on TechNet, to watch, share, and download the video in multiple formats. |
Video Summary
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.
Video Acknowledgements
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.