I have two sites hosted on two different data-centres. Recently one site has become very slow. The ping response from application server to DB server is not fast enough. How do I investigate the issue?
On fast server: 10 packets transmitted, 10 received, 0% packet loss, time 8998ms rtt min/avg/max/mdev = 0.243/0.279/0.502/0.074 ms On slow server: 21 packets transmitted, 21 received, 0% packet loss, time 20011ms rtt min/avg/max/mdev = 1.131/1.816/3.584/0.560 ms
The tracert command shows the following:
On fast server: tracert db traceroute to db (xxx.xxx.100.101), 30 hops max, 40 byte packets 1 db (xxx.xxx.100.101) 0.552 ms 0.530 ms 0.527 ms On slow server: tracert xxx.16.55.140 traceroute to xxx.16.55.140 (xxx.16.55.140), 30 hops max, 40 byte packets 1 xxx.16.55.140 (xxx.16.55.140) 1.859 ms 1.845 ms 1.842 ms