SSIS Interview Question | MaxConcurrentExecutables in SSIS | Parallel Execution of Tasks in SSIS

[@neerajsorout]

Sir when i changing the maxcuncuurentexecutables value ..every time all control flow task are running.

[@kalraanish1]

"My machine has 4 processors, and I have two tasks - so it will be six." What's the logic behind this "two"?

[@najafali5562]

It is number of logical processors of your CPU + 2. The logic behind "plus 2" is that each physical core in a CPU has a logical core the capability to do 2 or more things simultaneously, we call this ability the number of threads per core. You can find out the number of logical processors your CPU has in Task Manager -> Performance -> CPU. You can also use lscpu command in cmd to see number of threads per core in your PC CPU. Hoping this helps clarify your confusion :)

[@nirmalaprajapati04]

Please explain logic behind plus 2?

[@najafali5562]

It is number of logical processors of your CPU + 2. The logic behind "plus 2" is that each physical core in a CPU has a logical core the capability to do 2 or more things simultaneously, we call this ability the number of threads per core. You can find out the number of logical processors your CPU has in Task Manager -> Performance -> CPU. You can also use lscpu command in cmd to see number of threads per core in your PC CPU. Hoping this helps clarify your confusion :)

[@subhradeepghosh7209]

Thank you Sir

[@Training2SQLMSBI]

Thanks for your feedback..