Re: DTS and processors

#1

DTS has little if indeed anything to do with this. It i the configuration
of the SQL Server itself. All DTS does is issue queries for the engine to
execute.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"G" <G (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

Is it possible to force DTS to use all processor in a machine to probably
execute the packages faster? We have SQL Server 2000 Enterprise Edition

running on Windows 2000 Advanced Server that has 4 processor (8 hyper
threading). At the time the packages are scheduled to execute, we don't have
anything else running on the machine and wanted to take full advantage of
this fact.

Quote:

Thanks,
G.

#2

That simply limits the number of tasks that can go at one time. I
personally set this to a number which is Num' on processors in the box - 1
or 1. Any more than the number of processors in the box will cause context
switching which will hurt you for performance.

Allan

"G" <G (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks Allan. Then, what would the option "Limit the maximum number of
tasks excuted in parallel to:" do?

"Allan Mitchell" wrote:

DTS has little if indeed anything to do with this. It i the
configuration
of the SQL Server itself. All DTS does is issue queries for the engine
to
execute.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"G" <G (AT) discussions (DOT) microsoft.com> wrote in message
news:24C05A5D-14BD-46BE-93F9-B3506FAC9F5F (AT) microsoft (DOT) com...
Hi,

Is it possible to force DTS to use all processor in a machine to
probably
execute the packages faster? We have SQL Server 2000 Enterprise Edition
running on Windows 2000 Advanced Server that has 4 processor (8 hyper
threading). At the time the packages are scheduled to execute, we don't
have
anything else running on the machine and wanted to take full advantage
of
this fact.

Thanks,
G.

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

Re: DTS and processors

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

Re: DTS and processors - 06-25-2004 , 12:17 PM

Re: DTS and processors - 06-29-2004 , 04:16 AM