SQL server performance over long distance

Solution 1:

5000Kms at the speed of light would be ~17ms latency. Down optical fibre, more like 25ms. And that's a best case server-to-server fibre with no delays for media conversion, switching, routing, server response, etc.

Minimum is 25ms, guaranteed maximum 50ms...

yes there are tools to simulate a slow link, e.g.

http://jagt.github.io/clumsy/ - a Windows program for network traffic changing

http://wanem.sourceforge.net/ - a Linux LiveCD for WAN emulation

and lots of suggestions https://stackoverflow.com/questions/130354/how-do-i-simulate-a-low-bandwidth-high-latency-environment and https://stackoverflow.com/questions/1094760/network-tools-that-simulate-slow-network-connection