Platinum Sponsor

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
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    david_peter_hansen.jpg
    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.
    http://davidpeterhansen.com/ http://feeds.feedburner.com/DavidPeterHansen
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.