Hello:

I created and scheduled a DTS pkg., which basically copies
data from selected tables of one database to another.

The first time this job ran, it took more than three hours
to complete. However, every subsequent runs, completes in
approximately 11-12 minutes.

Is this normal? I would have thought that this would have
taken just as long as the first time I ran this job.

I'm running SQL2K using Storage Area Network attached
disks.

Thanks for all your responses.

There could be a few reasons for this.

Locking/contention (blocking)/network activity etc etc.



--

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



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