SSIS Engine Overview


As you peel back the layers of the Integration Services processing architecture, there are two separate subcomponents that can have a significant impact on performance and package efficiency. These are the SSIS Runtime engine and Data Pipeline engine. It is important to familiarize yourself with the purpose and behavior of these engines to make performance-tuning decisions.

Runtime Engine

The Runtime engine is a highly parallel workflow engine that coordinates the execution of tasks or units of work within SSIS and manages the engine threads that carry out those tasks. For the most part, the performance of the Runtime engine is most heavily influenced by conditions external to SSIS such as the number of available threads, the network bandwidth, and the interaction with external systems such as database servers, File Transfer Protocol (FTP) servers, or e-mail servers. When SSIS runs an Execute SQL task, for example, it sends a call to the target database and then waits for a response from the database server before it continues. In this scenario, the performance of the Execute SQL task is more dependent on the performance of the query execution than on the SSIS Runtime engine.

Data Pipeline Engine

When you use SSIS for data integration, in addition to the Runtime engine, you will use the Data Pipeline engine. The Data Pipeline engine is the underlying counterpart to a special task in SSIS called the data flow task. When the data flow task executes, the SSIS Data Pipeline engine extracts data from one or more data sources, performs any necessary transformations on the extracted data, and then delivers that data to one or more destinations.

With data integration solutions, you will likely focus a large part of your performance-tuning time on optimizing the Data Pipeline engine. Like the Runtime engine, the Data Pipeline engine is influenced by external conditions; however, within SSIS, there are a variety of settings that you can manipulate to tune the Data Pipeline engine's performance, based on the requirements of the data integration operations.




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net