jump to navigation

SSIS Parallel Processing March 9, 2009

Posted by Arshad Ali in SQL Server Integration Services, SSIS, SSIS 2008.
trackback
SSIS Parallel Processing
Parallel execution improves the performance on the computers that have multiple physical or logical processors. To support parallel execution of different tasks in the package, SSIS uses two properties: MaxConcurrentExecutables and EngineThreads.
In my next article on SSIS Parallel processing I will cover how you can utilize the parallel processing capabilities of SSIS. In the later part of this article, I will provide some tips for SSIS Performance optimization and finally I will talk of what you need to take care of when executing your SSIS Package on 64-bit computers.
Refer this link for more details.
http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_4_p1.aspx
Advertisements

Comments»

No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: