Using Parallel Processing
By now, you must have sensed that Integration Services packages can be configured to gain from parallel processing. You’ve learned optimization techniques earlier in this chapter that talked about managing buffers so that you could avoid swapping out buffers to disk and fit maximum rows in a buffer. Now you will learn how to make use of more processors available on your computer so that the packages run faster. Using both techniques—managing buffer utilization and using maximum CPUs on the computer—you can develop highly efficient packages that work with peak performance.
Running Parallel Tasks in the Control Flow
Recall that the tasks in the control flow are connected by precedence constraints and a task in the control ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services 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.
