Performance Tuning SQL Server Integration Services (SSIS)

In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced
SSIS options and how to avoid common SSIS mistakes. See how to measure performance and how to keep SSIS from monopolizing your server's resources. Lastly, discover SQL Server 2008 and 2012 features that will make SSIS more efficient.
Presented by Brian Knight at SQLBits XII
  • Downloads
    Slide deck available Slide deck 3.8 MB
    Video available MP4 Video HD 531 MB
  • SpeakerBIO
    Brian_Knight.jpg

    Brian Knight, SQL Server MVP, MCITP, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com, BIDN.com and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at PragmaticWorks.com. He is the author of more than a dozen SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.bidn.com

  • Video