June 22, 2009 at 9:21 am
Hi All,
Looking at putting in an application on two servers, one at HQ and one at another office. WAN link at the other office is 2mbps, and about 20ms average latency.
We have one SQL DB server that is located at HQ, and the two servers will use this one sever for their shared DB.
I presume MSSQL has no problem throwing data across a 20ms link (Assuming that there is always enough bandwidth available for it)
June 25, 2009 at 2:29 am
In the scenario you've given it is the application that is responsible for sending the traffic to SQL server so as long as the app is happy with the WAN you will find SQL server will be happy.
As a caveat to widen the answer I have sat at one end of a 2m link with a SQL server at the other doing all of my day to day work using Enterprise manager on SQL 2000 and the only slowness came about when I ran any DTS routines that demanded data was processed at the client end not the server end.
You should be fine.
June 25, 2009 at 2:39 am
Excellent, thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply