cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1994
Views
0
Helpful
7
Replies

Applications run tremendously slow via MPLS

Sergey Lubenkov
Level 1
Level 1

Hello,

My Database Applications run very very very slow when traversing a L3 MPLS (10mbps). 
The network latency is about 29ms and regular windows copies are fast, but it takes a while to run any application from the remote server. 

What could cause the so big delay to run apps?

Thank you,

Sergey

 

2 Accepted Solutions

Accepted Solutions

Joseph W. Doherty
Hall of Fame
Hall of Fame

You database applications are running slow compared to?

I.e. have you run them across any other WAN offering about 29ms latency?

View solution in original post

Disclaimer

The Author of this posting offers the information contained within this posting without consideration and with the reader's understanding that there's no implied or expressed suitability or fitness for any purpose. Information provided is for informational purposes only and should not be construed as rendering professional advice of any kind. Usage of this posting's information is solely at reader's own risk.

Liability Disclaimer

In no event shall Author be liable for any damages whatsoever (including, without limitation, damages for loss of use, data or profit) arising out of the use or inability to use the posting's information even if Author has been advised of the possibility of such damage.

Posting

Yes, your WAN slowness might be mostly due to WAN latency.

Often network applications are written very interactively and the additional latency, on WAN, can slow them greatly compared to LAN, where latency is often sub millisecond.

Your "regular windows copies are fast" likely because bulk data transfers have "windowing" which allows them to sometimes (eventually) copy as fast as they will on a LAN.  (If the Windows file copy, though, shows current transfer rate, you might notice the initially transfer rate takes a longer to get to full speed on the WAN vs. a LAN.  If you do, that's also because of WAN latency.)

Your latest post also mention IPSec and SSL VPN.  These too can slow things down a bit.  One notable potential issue is packet fragmentation for encrypted packets; this may, or may not, be happening on your database application.  Fragmentation generally only happens on nearly full sized packets.

View solution in original post

7 Replies 7

Tagir Temirgaliyev
Spotlight
Spotlight

проверь реальную скорость канала с помошью iperf с клиентского копьютера до сервера

также проверь мту и пропиши на интерфейсах реальный мту если отличается от 1500

 

если нет проблеи ни со скоростью передачи данных ни с мту тогда значит проблема в самой базе. там плохой дизайн таблиц плохой дизайн индексов или самого приложения.

у нас однажды разработчики в кавычках сделали програму которая копировала все таблицы с сервера на клиентский компьютер вместо того чтобы послать sql запрос на сервер базы данных

Joseph W. Doherty
Hall of Fame
Hall of Fame

You database applications are running slow compared to?

I.e. have you run them across any other WAN offering about 29ms latency?

Sergey Lubenkov
Level 1
Level 1

The Database App is running much slow via MPLS than running locally via LAN.

Also It running slow via IPSEC and SSL VPN, so I think it make sense to say that Database App running slow via WAN link. At the same time it works great via 10Mbs LAN.

Disclaimer

The Author of this posting offers the information contained within this posting without consideration and with the reader's understanding that there's no implied or expressed suitability or fitness for any purpose. Information provided is for informational purposes only and should not be construed as rendering professional advice of any kind. Usage of this posting's information is solely at reader's own risk.

Liability Disclaimer

In no event shall Author be liable for any damages whatsoever (including, without limitation, damages for loss of use, data or profit) arising out of the use or inability to use the posting's information even if Author has been advised of the possibility of such damage.

Posting

Yes, your WAN slowness might be mostly due to WAN latency.

Often network applications are written very interactively and the additional latency, on WAN, can slow them greatly compared to LAN, where latency is often sub millisecond.

Your "regular windows copies are fast" likely because bulk data transfers have "windowing" which allows them to sometimes (eventually) copy as fast as they will on a LAN.  (If the Windows file copy, though, shows current transfer rate, you might notice the initially transfer rate takes a longer to get to full speed on the WAN vs. a LAN.  If you do, that's also because of WAN latency.)

Your latest post also mention IPSec and SSL VPN.  These too can slow things down a bit.  One notable potential issue is packet fragmentation for encrypted packets; this may, or may not, be happening on your database application.  Fragmentation generally only happens on nearly full sized packets.

OK, good to know.

Do you think increasing of speed on WAN can help or there are will not be any difference for applications due to the same value of latency???


Also I noticed that DB apps are using SMB2 protocol for communication.

I am going to try SMB3 on Windows 8.

 

Disclaimer

The Author of this posting offers the information contained within this posting without consideration and with the reader's understanding that there's no implied or expressed suitability or fitness for any purpose. Information provided is for informational purposes only and should not be construed as rendering professional advice of any kind. Usage of this posting's information is solely at reader's own risk.

Liability Disclaimer

In no event shall Author be liable for any damages whatsoever (including, without limitation, damages for loss of use, data or profit) arising out of the use or inability to use the posting's information even if Author has been advised of the possibility of such damage.

Posting

If the problem is latency, increasing WAN bandwidth, unless there's congestion, will likely not help.

In Vista, and later, Windows version, Microsoft has made improvement to TCP and/or SMB, but again, they don't help a lot with distance based latency for interactive traffic.

OK, that make sense. Thank you for your help.

Review Cisco Networking for a $25 gift card