Hello,

I'm an absolute newbie when it comes to SQL. I was told that SQL
server does not function well on a WAN where network latency between,
say, the SQL server and a front-end server is greater than 250ms.

I can't find anything information supporting this claim online, so I
was hoping someone here could tell me if this is true or not?

Thank You!!

(jeff80 (AT) gmail (DOT) com) writes:
Of course, it helps if client and server are on a fast connection.
But it also depends on a lot of the application and how it is designed.
An application which does not retrieve huge amounts of data, and which
is well-written and not perform a lot of network roundtrips can perform
decently over a slower connection as well.

So there is no definitive answer to the question.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Depends what you are doing, database mirroring in full safety would be out
and yes, network latency in database mirroring is crucially important.

Replication is another area where you'd see lots of posts if network latency
where a problem, check out this MS article:
http://blogs.msdn.com/sqlcat/archive...ironments.aspx

Tony

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]