Multi-threaded db Compare

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
ribbles
Posts: 3
Joined: Fri 18 Jul 2014 00:49

Multi-threaded db Compare

Post by ribbles » Fri 18 Jul 2014 00:55

A DB compare operation takes an hour on my machine. I see that CPU and IO are under-utilized. I am running SQL server and Data Compare locally, connecting via shared memory. I am running with i7 4 core and SSD for the database.

Would the application benefit from some multi-threading?

alexa

Re: Multi-threaded db Compare

Post by alexa » Fri 18 Jul 2014 08:43

The tool works in multi-threading as it is.

We recommend you to check the server's performance and the tables' content. We suppose the weak place may lie in data transmission.

ribbles
Posts: 3
Joined: Fri 18 Jul 2014 00:49

Re: Multi-threaded db Compare

Post by ribbles » Mon 28 Jul 2014 05:21

Thanks for getting back to me.

In what way is it multi-threaded?

alexa

Re: Multi-threaded db Compare

Post by alexa » Mon 28 Jul 2014 09:36

Retrieving, comparing and caching data are multi-threaded.

ribbles
Posts: 3
Joined: Fri 18 Jul 2014 00:49

Re: Multi-threaded db Compare

Post by ribbles » Tue 29 Jul 2014 05:34

That's not what Microsoft Process Explorer shows:

Image

alexa

Re: Multi-threaded db Compare

Post by alexa » Mon 04 Aug 2014 13:27

We will reconsider the current behavior in future product versions.

Post Reply