O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Performance Boost in SSIS

by Pedro Perfeito

In this chapter, we will cover:

  • Control Flow Task and variables considerations for boosting performance
  • Data Flow best practices in Extract and Load
  • Data Flow best practices in Transformations
  • Working with buffer size
  • Working with performance counters

Introduction

When developing an integration SSIS project the most common concern is to guarantee that the data extracted from the source will be available to the end users as fast as possible. But if the scenario that lies ahead has huge data volumes moving from one source to some destination, performance concerns arise. What worked in a small data set will not work on big data sets.

If you keep in mind from an initial stage which tasks and which components ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required