22 Apr

MaxConcurrentExecutables

There are two kinds of spurs, my friend. Those that come in by the door; those that come in by the window.
Tuco – The Good, the Bad, and the Ugly (1966)

Once again, something that popped up in the MeasureUp practice test, that I missed, and so, a post.

The MaxConcurrentExecutables is set by right-clicking the Control Flow and selecting properties.  The following are valid values for this property:

  • -1: Sets the maximum numbers of concurrently running executables to the number of processors, plus 2.
  • 1 or greater: The number of threads that a package can execute.

Any value of 0 or less, except -1, will result in an error.

What I missed wasn’t that it set the number of threads, rather, that -1 is equal to the number of processors plus 2.

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.package.maxconcurrentexecutables.aspx

Leave a Reply

Your email address will not be published. Required fields are marked *