Performance Management

The essence of SSIS performance management is in understanding the mechanics of the processing engine and then making adjustments in the package design to work with these mechanisms. Package design is usually an iterative process that requires several design cycles to discover inefficiencies and to make appropriate design changes. Using the debugging and logging tools, you will learn to work through this process effectively and hone packages into their most simple and efficient form. The following principles define the core components of effective performance management:

  • Identifying execution trees

  • Reading and understanding execution plans

  • Optimization through iterative design

  • Effective use of execution parallelism

  • Maximizing ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.