Red Gate forums :: View topic - Need to speed up Compares and Deployments
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

Need to speed up Compares and Deployments

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Fri Apr 25, 2014 9:33 pm    Post subject: Need to speed up Compares and Deployments Reply with quote

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...
Back to top
View user's profile Send private message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 64

PostPosted: Fri Apr 25, 2014 9:56 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 91

PostPosted: Fri Apr 25, 2014 10:45 pm    Post subject: Reply with quote

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/display/SDC10/Improving+the+performance+of+SQL+Data+Compare

Hope that helps.

Regards,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group