Chapter 11. Optimizing SSIS Packages
After completing this chapter, you will be able to:
Generally understand the SSIS engine components and processes.
Review the memory buffer architecture.
Monitor package execution trees and their impact on package performance.
Manage buffer properties.
Manage task and component parallelism.
Understanding performance management essentials.
Use iterative optimization techniques to simplify and tune a package design.
Microsoft SQL Server 2005 Integration Services (SSIS) goes a long way toward ensuring optimal performance with little direct input from the person designing packages. As much as possible, the execution engine will make intelligent decisions about the appropriate use of buffer allocation, memory usage, and ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
