cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MEGA RDBMS Slow Response hrPING

Solved
Frequent Contributor

MEGA RDBMS Slow Response hrPING

Hello,
 

We are having Performance issues with RDBMS set-up in different Locations. 
Location where DataCenter is set-up is workable(but there are delays)  but rest of the locations are facing lot of problems while Login, Dispatching.

To know whats problem I executed hrPING utility to know Network Capability to Database Server. I got result as follows

 

[2014.22.05 13:13:54,53] "==============>> Start hrping       "

 

This is hrPING v3.10 by cFos Software GmbH -- http://www.cfos.de

2014-05-22 13:13:54.827: -W -l 5000 -n 50 -y 10.104.145.41  -F C:\TEMP\hrping.log -T
Source address is 10.104.185.11; using ICMP echo-request
Pinging 10.104.145.41
with 5000 bytes data (5028 bytes IP):


Statistics for 10.104.145.41:
  Packets: sent=50, rcvd=50, error=0, lost=0 (0% loss) in 24.502021 sec  
  RTTs of replies in ms: min/avg/max/dev: 1.578 / 3.414 / 6.339 / 1.626  
  Bandwidth in kb/sec: sent=10.260, rcvd=10.260  
 
[2014.22.05 13:14:19,35] "<<============== End hrping   "

 

 

But in Article Repository - RDBMS Installation Guide MEGA 2009 SP5 it mentioned

If the value returned for

"RTTs of replies in ms/avg" (0.535 in the example) is higher than 1 ms, contact MEGA.

For us RTTs of replies in ms/avg 3.414 . is this value is normal ?

 

Colruyt Team
Tags (2)
3 Replies
Highlighted
MEGA

Re: MEGA RDBMS Slow Response hrPING

Hello

 

The requirement for RDBMS storage is a latency lower than 1ms

 

Run the following command and check the value for 'avg'

hrping.exe -W -l 5000 -n 50 -y <myserver>
pause

where <myserver> is the database server name

 

See also

http://community.mega.com/t5/custom/page/page-id/mega-kb-solution?sid=501D0000000LnZzIAK

Jerome
Highlighted
Regular Contributor

Re: MEGA RDBMS Slow Response hrPING

that's the command we did use. We have values between 3.5 and 5.5 ms depending on the time of the day.

Highlighted
MEGA

Re: MEGA RDBMS Slow Response hrPING

Hello

 

The requirement for RDBMS storage is a latency lower than 1ms

With values such as 3.5 and 5.5 ms you are above requirement and delays are predictable

Jerome