Need to speed up Compares and Deployments

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Need to speed up Compares and Deployments

Postby SQL_ME_RICH » Fri Apr 25, 2014 9:33 pm

I have 2 databases. One has 4 views that produce a result set that I need to compare/sync with another database that holds the result sets in tables.

The only difference in the result sets is that the tables have a lead column (called ID) that is used for uniqueness (Primary Key and Clustered Index).

The problems I am having are everything from speed of the compare and deployments to not being able to deploy at all with claims being made in the form of warnings say nothing can be updated in the table.

The servers are VM's. They are located here in our data center on the same network and backbone (only 1gb but better than a WAN link).

I need to get some ideas on how to optimize things, so if I need to give a call for support - I can definitely elaborate more, but I am in the 14 day trial period, and really need to come up with some solutions.

Please advise...
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby SQL_ME_RICH » Fri Apr 25, 2014 9:56 pm

P.S. The result sets of the 4 views and stored space in the 4 tables constitutes about 20 million rows and about 20gb of storage.
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Evan Moss » Fri Apr 25, 2014 10:45 pm

Hello,

Thanks for your post.

This article on performance in SQL Data Compare details the variables to keep in mind and some strategies for optimization: http://documentation.red-gate.com/displ ... ta+Compare

Hope that helps.

Regards,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests