Posted by Tony Rogerson on 10/16/07 08:00

> 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.
>

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/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.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]

• Next in forum: mmsql - transact
• Prev in forum: large data management
• Thread view: Re: sql server doesn't work well with 250ms+ network latency

[Reply to this message]