I know that one reason to employ EOC is if the size of your network exceeds what can be handled by one SQL instance. However, I also know it can be required if network latencies are too high.
But, what latency values would typically be high enough to indicate the need for multiple databases and the EOC for roll up? What latency can SQL tolerate?
Thank you.