DTS is *s*l*o*w*

[Scott Eldridge]

We've found DTS to be much, much slower than good old "object transfer".
Using DTS to make a copy of a 28 mb database (onto the same machine) took about 90 minutes.

Any similar experiences?

[Tom]

What type of transfer method are you using. Are you using OLE DB or ODBC. ODBC goes at a crawl. If you are using OLE DB for SQL Server this flies because it uses the new Bulk Insert method.

Check to see what connection type you are using. Also are you createing new tables or are you just transfering data?
Tom
On 1/19/99 11:49:17 AM, Scott Eldridge wrote:
> We've found DTS to be much, much slower than good old "object
> transfer".
Using DTS to make a copy of a 28 mb database (onto the
> same machine) took about 90 minutes.

Any similar experiences?

[Eleanor LeClair]

I've noticed that sometimes it depends on where you are running your Enterprise Manager. For example, loading data from one server to another from a PC workstation is MUCH slower than going to the target server and running DTS from there. Why? It appears DTS is taking the data from the source server, loading it on the PC, then sending it to the target server. Running the operation from the server eliminates the need to send the data back over the network.

I suspect while your databases are both on the same server, you were running the operation from another machine.


On 1/19/99 11:49:17 AM, Scott Eldridge wrote:
> We've found DTS to be much, much slower than good old "object
> transfer".
Using DTS to make a copy of a 28 mb database (onto the
> same machine) took about 90 minutes.

Any similar experiences?

[Michael Yocca]

I agree with this comment.

One way you may find the bottleneck is to run performance monitor and
look for where the activity is occurring.

It has been my experience that DTS is very fast.

-my


------------
Eleanor LeClair at 1/21/99 9:08:32 AM

I've noticed that sometimes it depends on where you are running your Enterprise Manager. For example, loading data from one server to another from a PC workstation is MUCH slower than going to the target server and running DTS from there. Why? It appears DTS is taking the data from the source server, loading it on the PC, then sending it to the target server. Running the operation from the server eliminates the need to send the data back over the network.

I suspect while your databases are both on the same server, you were running the operation from another machine.


On 1/19/99 11:49:17 AM, Scott Eldridge wrote:
> We've found DTS to be much, much slower than good old "object
> transfer".
Using DTS to make a copy of a 28 mb database (onto the
> same machine) took about 90 minutes.

Any similar experiences?