sql server doesn't work well with 250ms+ network latency

jeff80

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

Oct 15 '07 #1

Subscribe Reply

6019

Erland Sommarskog

(je****@gmail.c om) writes:

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?

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, es****@sommarsk og.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

Oct 15 '07 #2

Tony Rogerson

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

Oct 16 '07 #3

Similar topics

3648

High volume websites using Python web server software?

by: Irmen de Jong | last post by:

Hi, Things like Twisted, medusa, etc.... that claim to be able to support hundreds of concurrent connections because of the async I/O framework they're based on.... can someone give a few examples of some web sites actually using those Python frameworks? Thanks :) --Irmen

Python

2711

sql server and vpn: performance/speed

by: JENS CONSER | last post by:

Hello NG, We have a performance problem in using a client server solution based on MS SQL-Server 2000 through a VPN tunnel (via broadband internet connection). The SQL Server is running on a Windows 2003 Server which is configured as VPN server as well. We figured out that not the performance

Microsoft SQL Server

13962

"Timeout expired" for simple ADO.NET SQL Server query

by: Nils Magnus Englund | last post by:

Hi, I've made a HttpModule which deals with user authentication. On the first request in a users session, it fetches data from a SQL Server using the following code: using (SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings)) {

ASP.NET

4304

MSSQL connection from PHP slower when server is remote (crosspost)

by: gharmel | last post by:

I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server #1 MSSQL 2000 sp4 Windows 2000 Server PHP4 on IIS5 (CGI)

PHP

1800

Fast Rename from client to server

by: Don Curtis | last post by:

I have a C# client app that sometimes needs to do thousands of specialized file renames of files on a file server in the same domain. If the files reside locally on the client machine, the renames take only a few seconds. If the files reside on the file server, a set of 30,000 file renames may take a half hour to do. I'm just using...

C# / C Sharp

2680

Twisted server and protocol question

by: Benry | last post by:

Hi guys. I hope I can discuss Twisted here. If not, direct me to the correct place please. My question(s): I'm working on a custom network protocol (application layer in TCP/IP model) for a custom network. Please don't try to talk me out of this. I'm limiting many of the other protocols, because this is in a highly secure network, and...

Python

3336

sql server i/o bottle neck ?

by: dunleav1 | last post by:

I built a test job that loads data into the database. I get great performance with Oracle and I'm trying to tune Sql Server to get the same type of performance. Based on system monitoring it looks like an I/O issue. So I started investigating based on sql server perfromance tuning technical reference. Here are my system monitor findings:...

Microsoft SQL Server

2544

Online Connection between Access and SQL Server

by: Michael | last post by:

Hello, I am trying to develop a database solution for an organisation in Indonesia. This organization has a number of offices and users throughout the country. They all need to maintain their own data, but I also need to create a central database, to store all of the data, and share data between the individual users. The problem is that...

Microsoft SQL Server

2835

Distributed chat server

by: Ronald Green | last post by:

Hi, I have this theoretical problem: Say that I need a chat server that also has a database where it saves all conversations. However, I need several servers for availability and load balancing. Now arises the problem of how to synchronize the servers in the shortest interval (synchronize databases that is). I'm not sure that merge or...

C# / C Sharp

7467

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7807

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7756

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

4944

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3450

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3442

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1879

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1014

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

703

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General