The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

SSIS Performance

Thu, Sep 28 2017 18:00 UTC

SSIS Performance

So you've developed a whiz-bang SSIS package to push around a bunch of data. You save it, run it, and.... nothing happens - or it moves verrrrry slowly. Or perhaps you've got packages that run reasonably well, but you're convinced they could run faster. Where do you start troubleshooting? How do you eliminate those performance pain points? In this demo-packed session, we'll work through some of the most common causes of performance bottlenecks in SSIS packages, along with recommended practices for maximizing performance. Among the topics we'll cover: · Troubleshooting methods to detect performance hotspots · Optimizing sources and destinations for maximum throughput · Choosing the most efficient data flow transformations · Using parallelism to improve performance. This presentation is ideally suited for those with some experience using SSIS.


Tim Mitchell

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQL Saturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids