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
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 ?
Solved! Go to Solution.
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