I have the branches installed now and the max parallel tasks set at 15 just
in case. But for some reason after about 9 or 10 steps it reverts back to
running only one step. It trades off the after each step back and forth until
it is complete. Very strange. It starts off fine running the branches at the
same time so I know part of it is working but for some reason it always
reverts back to running only one step at a time.
Is there a reason for this?
Again thanks for your help
[quoted text, click to view] "Chris" wrote:
> Great Thanks Dan,
>
> -Chris
>
>
> "Dan Guzman" wrote:
>
> > Multiple steps can run concurrently as long as:
> >
> > 1) steps are not constrained by workflow precedence with the package
> >
> > 2) package properties specify max parallel tasks > 1 (default is 4)
> >
> > 3) the package is run from a multi-threaded app like DTSRUN or Enterprise
> > Manager
> >
> > Note that multiple steps can be dependent on the same predecessor and
> > subsequent steps are free to run once the predecessor completes. For
> > example, you can load a staging table and then run multiple Execute SQL
> > tasks in parallel after the load successfully completes.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Chris" <Chris@discussions.microsoft.com> wrote in message
> > news:7C9CE8FB-55A6-4780-B5B5-10653A47EA04@microsoft.com...
> > > Is there a way to run two DTS steps at the same time? I need to speed a
> > > job
> > > up that kicks off a DTS package and in the DTS package there are many
> > > steps.
> > > None of them rely on each other to finish, except for one at the very end,
> > > but I can speed it up if I branch off a few steps to run at the same time.
> > >
> > > Is this possible?
> > >
> > > Thanks for your help
> > >
> > > -Chris
> > >
[quoted text, click to view] > It trades off the after each step back and forth until
> it is complete.
I'm not sure what might be going on here but perhaps these processes are
resource intensive so only one can run at a time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
[quoted text, click to view] "Chris" <Chris@discussions.microsoft.com> wrote in message
news:A1155932-7F48-4065-B135-7865784925A3@microsoft.com...
>I have the branches installed now and the max parallel tasks set at 15 just
> in case. But for some reason after about 9 or 10 steps it reverts back to
> running only one step. It trades off the after each step back and forth
> until
> it is complete. Very strange. It starts off fine running the branches at
> the
> same time so I know part of it is working but for some reason it always
> reverts back to running only one step at a time.
>
> Is there a reason for this?
>
> Again thanks for your help
>
> "Chris" wrote:
>
>> Great Thanks Dan,
>>
>> -Chris
>>
>>
>> "Dan Guzman" wrote:
>>
>> > Multiple steps can run concurrently as long as:
>> >
>> > 1) steps are not constrained by workflow precedence with the package
>> >
>> > 2) package properties specify max parallel tasks > 1 (default is 4)
>> >
>> > 3) the package is run from a multi-threaded app like DTSRUN or
>> > Enterprise
>> > Manager
>> >
>> > Note that multiple steps can be dependent on the same predecessor and
>> > subsequent steps are free to run once the predecessor completes. For
>> > example, you can load a staging table and then run multiple Execute SQL
>> > tasks in parallel after the load successfully completes.
>> >
>> > --
>> > Hope this helps.
>> >
>> > Dan Guzman
>> > SQL Server MVP
>> >
>> > "Chris" <Chris@discussions.microsoft.com> wrote in message
>> > news:7C9CE8FB-55A6-4780-B5B5-10653A47EA04@microsoft.com...
>> > > Is there a way to run two DTS steps at the same time? I need to speed
>> > > a
>> > > job
>> > > up that kicks off a DTS package and in the DTS package there are many
>> > > steps.
>> > > None of them rely on each other to finish, except for one at the very
>> > > end,
>> > > but I can speed it up if I branch off a few steps to run at the same
>> > > time.
>> > >
>> > > Is this possible?
>> > >
>> > > Thanks for your help
>> > >
>> > > -Chris
>> > >
>> >
Don't see what you're looking for? Try a search.
