Integration Services (SSIS) internals and performance tuning

Back in 2014 I created a 214 page deck for a pre-con at SQLSaturday Johannesburg and Cape Town. Since then I’ve presented it at a good number of large and small conferences.

As I don’t really work much with SSIS anymore, I thought I’d publish the entire deck here and hopeful someone would find value in it.

The material is quite text-heavy, so it should be readable, and it is compiled from a number of sources (see the last four slides). Also, please note that it doesn’t cover SSIS 2016 and some of the buffer optimizations that came in that version.

Integration Services (SSIS) internals and performance tuning

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s