Slow DTS

[J.Salfer]

Hello,

Were using the data transfermation service to copy in an Ingres II 2.5
database to an SQL Server 2000 database. Small databases don't present an
issue, but when pulling one across that's about 20GB its been taking between
12 and 24 hours. Both systems are relitively quick boxes and neither of them
are tapped out on processor, disk I/O or network resources.

I do have the "Boost SQL Server priority on Windows" checked under it's
properties and all the processors are checked to be used.

Does anyone know if there's a way to tweak SQL Server or Ingres to handle
this a little quicker? Or even an idea where the bottleneck could be may be
helpful.

Thanks,
John.

[John Bell]

Hi

A couple of thoughts!

You may want to check the transformation properties and see if they are all
on the main thread, or if they are not using fast load, or experiment with
changing the insert batch size improves the performance.

It is not clear what drivers you are using for this, if there is an OLEDB
driver try using that if you aren't already.

Alternatively if you have the means to create text data files, then you
could export/import in two stages writing a BCP script to read them in.

John

"J.Salfer" <Jo***@VoyageurSoftware.com> wrote in message
news:43**********@newspeer2.tds.net...

Hello,

Were using the data transfermation service to copy in an Ingres II 2.5
database to an SQL Server 2000 database. Small databases don't present an
issue, but when pulling one across that's about 20GB its been taking
between 12 and 24 hours. Both systems are relitively quick boxes and
neither of them are tapped out on processor, disk I/O or network
resources.

I do have the "Boost SQL Server priority on Windows" checked under it's
properties and all the processors are checked to be used.

Does anyone know if there's a way to tweak SQL Server or Ingres to handle
this a little quicker? Or even an idea where the bottleneck could be may
be helpful.

Thanks,
John.