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 contains a data flow task that has 10 source-to-destination
execution trees.
Only five of the source-to-destination execution trees are running in parallel.
You need to ensure that all the execution trees run in parallel.
What should you do?
A.
Add OnError and OnWarning event handlers.
B.
Create a new project and add the package to the project.
C.
Query the ExecutionLog table.
D.
Add an Execute SQL task to the event handlers.
Why is A? I think there is no currect answer.
It seems like an ‘EngineThreads’ issues
0
0
weird answers..
0
0
Yes, seems to be an Engine Threads or MaxConcurrentExecutables setting issue…
According to MSDN:
To understand how this property works, consider the sample package with three Data Flow tasks. Each of Data Flow task contains ten source-to-destination execution trees. If you set EngineThreads to 10 on each Data Flow task, all 30 execution trees can potentially run simultaneously.However, the general rule is not to run more threads in parallel than the number of available processors. Running more threads than the number of available processors can hinder performance because of the frequent context-switching between threads.
0
0
Correct. Answer should be to set EngineThreads setting to 10 in this instance with only one data flow task and ten source-to-destination execution trees.
0
0
I agree none of these answers are correct
0
0
I agree these are not relevant option for Answer.
0
0
This is a duplicate of Q 192. That one has correct answers.
1
0
Yes. Thank you.
0
0
Agreed with pb7788, I found similar information at;
https://msdn.microsoft.com/en-us/library/ms141031(v=sql.110).aspx
0
0