SQL Session – Performance Tuning in SSIS

If you’re not already a member of the Charlotte SQL Server User Group, go now and sign up. This group is a great resource of knowledge and connections to the SQL Server community in Charlotte, NC. Their plan is to get together once a month and discuss a new and interesting topic on SQL Server.

If you missed it, John Welch covered many details of performance optimization for SSIS data flows, including optimizing execution trees, managing buffer size, and evaluating performance metrics to determine where the bottlenecks are. Also covered were the logging options and performance counters that can be used to monitor performance.

Unfortunately, I don’t have any materials to share with you on this meeting. Maybe next time!


No Responses to “SQL Session – Performance Tuning in SSIS”

  1. AndrewBoldman 20100306 at 00:00 #

    Hi, cool post. I have been wondering about this topic,so thanks for writing.

Leave a Reply

Notify me of followup comments via e-mail. You can also subscribe without commenting.