Re: DTS connection speed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Does sound strange.

Couple of questions

Are all the DTS packages using the same Provider?
The same connection?
Are they going to the same server?

What about copying a file or using a different medium to transfer the data using the same connection means/driver?

Allan



"Ben Rum" <bundyrum75@xxxxxxxxx> wrote in message news:uKiApnyzFHA.1028@xxxxxxxxxxxxxxxxxxxx:

I have 4 dts's which transfer data from SQL Server (2000 SP4) to Oracle
8.1.4.7

The distance is large (Europe to Asia) so timing isn't great. However
one of
the DTS's runs extremely slow, compared to the others for no reason that
I
can see.

Each of the 4 dts's transfer roughly 5-200 rows, and 3 out of the 4
dts's
take around 1-2 minutes. However the 4th dts takes AT LEAST 1 hour to
run,
even if a very small number of rows are being sent. The timing doesnt'
seem
to change at all whether its sending 2 or 200 rows, so it seems to be
the
actual connection rather than the row insert taking the time.

The slow DTS has been on the gradual increase since it started - so
there is
no major "spike" in the timings. Initially the same amount of data would
insert in around 4-5 minutes, and its slowly (over about 1 year) gone up
to
1 hour - with no change in the number of rows being inserted.

Has anyone eny insights or thoughts?

Many Thanks, Ben 

.

Relevant Pages

  • Re: Way, way, way OT
    ... I have a microscopic connection ... My interest was synchronizing and reconfiguring ... of applied timing and I wanted to go in a new direction... ... driven by the work and not position within academia. ...
    (rec.motorcycles.dirt)
  • Re: HDMI detects lower resolution than VGA
    ... Don't bother with the shelf timings worry only about the resolution itself ... Now I see that the NVIDIA display shows the monitor model as "32LB132B5", ... The list of timing modes available do not include something similar to ... I setup everything through the VGA connection in my TV: ...
    (microsoft.public.windows.mediacenter)
  • Re: Trouble with sa password
    ... In your DTS packages how are your SQL Server ... > I have Windows Authentication in the Connection ...
    (microsoft.public.sqlserver.security)
  • Re: RWW timing out after 20 minutes
    ... i don't see any posts where making the appropriate registry ... I am having problems with RWW timing out even if users are working on ... I tried to change the registry settings as suggested ... the connection still drop at 20 minutes.. ...
    (microsoft.public.windows.server.sbs)
  • Re: The young one,
    ... I've been unable to connect to Ecosse sites again today. ... Connection keeps timing out ...
    (uk.people.silversurfers)