June 2007
Beginner to intermediate
480 pages
12h 30m
English
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 ...
Read now
Unlock full access