performance issues with a server on another continent
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.