You are performance tuning a SQL Server Integration Services (SSIS) package to load sales data from a source system into a data warehouse that is hosted on Windows Azure SQL Database. The package cont

Question

Options

• ASet the EngineThreads property of the data flow task to 7.
• BSet the MaxConcurrentExcecutables property of the package to 7.
• CCreate seven data flow tasks that contain one source-to-destination execution tree each.
• DPlace the data flow task in a For Loop container that is configured to execute seven times.

• A
  60% (24)
• B
  10% (4)
• C
  25% (10)
• D
  5% (2)

Explanation

The EngineThreads property on the Data Flow task controls how many threads the SSIS data flow engine allocates to process execution trees in parallel. Each execution tree is a segment of the data pipeline that can run on its own thread. The default value of EngineThreads is typically 5, which is why only 3 of the 7 trees were running in parallel (the engine was thread-limited). Setting EngineThreads to 7 gives the engine enough threads to run all 7 execution trees simultaneously. Option B (MaxConcurrentExecutables) controls how many control flow tasks run in parallel across the package, not execution trees within a single data flow task. Options C and D are workarounds that restructure the package unnecessarily.

No community discussion yet for this question.