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.
No comments:
Post a Comment