Queries between servers

This has happened multiple times but I will only mention one story to lay the
groundwork.
One of our data servers crashed. We built a new box from scratch (the only
difference is that it's x64 OS instead of x32), and I got the databases back
online from the system dbs and the SAN.
We have had a problem when DTS packages run from a remote server that the
time it takes to run has increased over time. The servers are linked, and I
guess they were before I got here so I am not sure about settings and such.
I just realized that in one of the instances the service packs differ b/t 3
and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box and
it still happens.
Where should I begin to look to see how to fix or address this slowness? Any
tips are appreciated.
ThanksThere is a HUGE range of things that could be causing your issue. someone
modified a setting or structure, san setting changes or workload, service
pack diffs, 32/64bit driver diffs, os file fragmentation, internal database
data/index fragmentation, etc, etc. You could spend days or even weeks
going back and forth on this forum answering follow-on questions from
posters to try to isolate the problem (if there even is one) and get no
where. Or you could call microsoft or get with a consultant and pay a
professional to isolate the situation for you. My bet is that the latter
will provide a much better ROI.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"jason7655" <jason7655@.discussions.microsoft.com> wrote in message
news:75BA70E2-2C0E-407F-BBDD-7C8C9481193C@.microsoft.com...
> This has happened multiple times but I will only mention one story to lay
> the
> groundwork.
> One of our data servers crashed. We built a new box from scratch (the only
> difference is that it's x64 OS instead of x32), and I got the databases
> back
> online from the system dbs and the SAN.
> We have had a problem when DTS packages run from a remote server that the
> time it takes to run has increased over time. The servers are linked, and
> I
> guess they were before I got here so I am not sure about settings and
> such.
> I just realized that in one of the instances the service packs differ b/t
> 3
> and 4, but there are other DTS jobs that go from an SP4 box to an SP4 box
> and
> it still happens.
> Where should I begin to look to see how to fix or address this slowness?
> Any
> tips are appreciated.
> Thanks