What Is MaxConcurrentExecutables Property in SSIS Package?

MaxConcurrentExecutables is SQL Server Integration Services Pacakge level property that defines that how many tasks can run simultaneously(parallel).
By default the value of this property is set to -1 that means that It will be able to run Total Tasks=Number of processors+2.
As we can see in below Fig 1. The SSIS Package is executing 6 Data Flow Tasks as MaxConcurrentExecutables value is set to default(-1). My machine has 4 processors.

Fig 1: MaxConcurrentExecutables set to default value (-1)

If you are sharing your Server to run other application/s ,  then you might not want to use all the resources for SSIS. In that case, you can set the MaxConcurrentExecutables value to small number.Let's set the MaxConcurrentExecutables=2 in package and run the package and see if it is only executing only two tasks in parallel.

Fig 2: Setting MaxConcurrentExecutables property value to low number to share Resources

As we can see that only two Tasks are executing in parallel. If you are changing the MaxConcurrentExecutables value from default to some higher number, Test your SSIS Package to make sure you are getting better performance than default setting as well no other application/process is being effected by new SSIS Package setting.

Let's set MaxConcurrentExecutables =10 and see if all the Tasks are executing parallel.
Fig 3: Setting MaxConcurrentExecutables to higher value to run more Tasks in Parallel

16 comments:

  1. This is very useful. However I have 16 Physical Processors and I keep MaxConcurrentExecutables = -1 The default setting. So in my case,Total Tasks=Number of processors+2 = 16+ 2 =18. I have 10 DFTs and still its running only 6 at a time. Can you tell me why?

    ReplyDelete
    Replies
    1. it is the logical processor rather than the physically present processor that is counted.

      Delete
  2. Audio started playing as soon as I opened this website, so frustrating! affordable skip tracing

    ReplyDelete
  3. They're produced by the very best degree developers who will be distinguished for your polo dress creating. You'll find polo Ron Lauren inside exclusive array which include particular classes for men, women. Confidence Training Perth

    ReplyDelete
  4. A very important consideration when buying any investment property is to decide what is more important to you, YIELD or CAPITAL GROWTH, or a good combination of the two?Forestry Mulching

    ReplyDelete
  5. The media is currently full of real estate 'doom and gloom' - real estate repossessions and arrears are up and real estate prices are down ... SC Realtor

    ReplyDelete
  6. Our working capital assumption represents additional capital we think we'll need in order to cover the day-to-day management of the investment property. We may have certain expenses that aren't fully covered by our rental income and our working capital will help make sure we don't run into cash flow problems.SubZero, Viking Ice Maker Repair Near Me

    ReplyDelete
  7. Property documentation thinking about a wide range of inhabitance ought to be sourced. property management Galway

    ReplyDelete
  8. The quarterly checking measure considers acclimations to the spending when unordinary things of salary and consumption are obvious. for more information

    ReplyDelete
  9. property wealth advisor northern beaches It's an intense street to pull alone - that is the reason having a decent Property Advisor proves to be useful.

    ReplyDelete
  10. i never know the use of adobe shadow until i saw this post. thank you for this! this is very helpful. galway property services

    ReplyDelete
  11. Wow, What a Excellent post. I really found this to much informatics. It is what i was searching for.I would like to suggest you that please keep sharing such type of info.Thanks wasl properties for rent

    ReplyDelete
  12. If you are looking for more information about flat rate locksmith Las Vegas check that right away. Sofa wash near me

    ReplyDelete
  13. I set 128 and still it falls to me because the connection to DB is locked

    ReplyDelete
  14. Hey There. I found your blog using msn. This is a very well written article. I’ll be sure to bookmark it and come back to read more of your useful info. Thanks for the post. I’ll definitely return. Gibraltar estate agency

    ReplyDelete
  15. The following appears to be like unquestionably fantastic. Almost all these minor points are built by using number of foundation awareness. I enjoy them considerably property for sale gibraltar

    ReplyDelete