Scheduling DTS package use 50% of my cpus

#1

hi,

I have a lot of packages executed from 1 package.
when I execute the main package interactively, my 2 processors are used at
100%
(execution directly from the DTS designer)

when I schedule the same package using a .BAT file and executed from the SQL
Server agent, the CPU usage is 50% (near 50% of each CPU)

any idea?
thanks.

#2

Jéjé,

What about the timing?

Ilya

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

Quote:

hi,

I have a lot of packages executed from 1 package.
when I execute the main package interactively, my 2 processors are used at
100%
(execution directly from the DTS designer)

when I schedule the same package using a .BAT file and executed from the
SQL
Server agent, the CPU usage is 50% (near 50% of each CPU)

any idea?
thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Scheduling DTS package use 50% of my cpus

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Scheduling DTS package use 50% of my cpus - 02-07-2005 , 11:28 PM

Re: Scheduling DTS package use 50% of my cpus - 02-09-2005 , 07:45 AM