How can we help you today? How can we help you today?

performance issues with a server on another continent

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
0

Comments

2 comments

Sort by
  • David Atkinson
    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
    0
  • vadimgin
    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
    0

Add comment

Please sign in to leave a comment.