performance issues with a server on another continent

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

performance issues with a server on another continent

Postby vadimgin » Thu Jun 28, 2012 4:10 pm

Hello.
One of my servers has moved across the atlantic. The pipe is very good, but comparing schema with a local server has become an issue.

Comparing a database between 2 local servers takes about 5 minutes (about 4,000 objects).

Comparing it between a local server and the transatlantic server takes well over an hour, which is not acceptable.

The issue it seems lies with thousands upon thousands of roundtrips which all execute DBCC PAGE

Can this behavior be modified? Are there any settings that I can change that can change this roundtripping behavior and fetch the data in one go?

thanks for any tips.
vadimgin
 
Posts: 2
Joined: Fri Sep 14, 2007 12:04 pm

Postby David Atkinson » Thu Jun 28, 2012 4:49 pm

You could take a schema snapshot using the free SQL Snapper app and run the comparison locally? Would this work?

David Atkinson
Red Gate
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby vadimgin » Thu Jun 28, 2012 5:42 pm

thank you, that would work as a workaround, but very inconvenient as opposed to direct compares.

why does it use dbcc page anyway? it makes a round trip for every single page in the compare. any work in the pipeline to optimize it?
vadimgin
 
Posts: 2
Joined: Fri Sep 14, 2007 12:04 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests