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.
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 ICT Database Developer at United Nations Office for Project Services (UNOPS). He specializes in developer coaching as well as scalable architecture and performance tuning on large-scale data warehouses and BI solutions. He is a frequent speaker at conferences, and have given talks in Europe, USA, and South Africa.