SSIS internals and performance

You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before.

In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems. You will also learn how the control flow engine and data flow engine work, what the impact on performance buffers have, and how execution trees are related to parallelism. 
  • Downloads
    Video available MP4 Video HD 526 MB
  • SpeakerBIO
    David Peter Hansen is a Microsoft Certified Master (MCM) and has over a decade of experience with database development and administration on SQL Server and the Microsoft Business Intelligence platform. Today, he works as Senior Premier Field Engineer at Microsoft. He specializes in delivering training as well as scalable architecture and performance tuning on large-scale data platform solutions. He is a frequent speaker at conferences, and have given talks in Europe, USA, and South Africa.
  • Video