The SSIS Tuning Tip That Everyone Misses

Execution Plan Example

If you are a person that uses SQL Server Integration Services (SSIS) a great deal, you have probably spent hours looking through you ETL processes trying to find ways to make the processes faster and more efficient. Rob Farley has written an article that describes what you can do to possibly speed up your processing with minimal effort.

When debugging SSIS, you run the package, and sit there waiting to see the Debug information start appearing. You look for the numbers on the data flow, and seeing operators going Yellow and Green. Without the hint, I’d sit there for a minute. With the hint, just ten seconds. You can imagine which one I preferred.

By adding this hint, it felt like a magic wand had been waved across the query, to make it run several times faster. It wasn’t the case at all – but it felt like it to SSIS.

 Maybe you will find this information useful in your development.

Advertisements

1 thought on “The SSIS Tuning Tip That Everyone Misses”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s