These are the main steps to tune the SSIS Packages:
1.Generally understand the SSIS engine components and processes.
2.Review the memory buffer architecture.
3.Monitor package execution trees and their impact on package performance.
4.Manage buffer properties.
5.Manage task and component parallelism.
6.Understanding performance management essentials.
7.Use iterative optimization techniques to simplify and tune a package design.
Each step will be described breifly in the next coming posts,please check.
No comments:
Post a Comment