Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am getting bad ping times on my server, especially for large data requests. The stored procedure on the server runs at 1 second, while calling it through my web applicaiton takes 23+ seconds. This never happened before, until my server was restroed after my host crashed, now large queries are pretty slow and pings around from 70-150ms. Does the trace route below show anything out of the ordinary?

   C:\Users>tracert example.com

    Tracing route to example.com [222.22.22.22]
    over a maximum of 30 hops:

      1    <1 ms    <1 ms    <1 ms  WRT610N [192.168.1.1]
      2     7 ms     7 ms     8 ms  10.49.128.1
      3     9 ms     9 ms    11 ms  172.21.0.200
      4    12 ms    15 ms    12 ms  70.169.77.248
      5     9 ms     8 ms     9 ms  chnddsrj01-ae2.0.rd.ph.cox.net [70.169.76.229]
      6     9 ms    11 ms     9 ms  ae56.bar1.Phoenix1.Level3.net [4.31.188.61]
      7    56 ms    55 ms    55 ms  ae-8-8.ebr1.Dallas1.Level3.net [4.69.133.30]
      8    57 ms    55 ms    56 ms  ae-1-12.bar2.Tampa1.Level3.net [4.69.137.117]
      9    69 ms    67 ms    67 ms  WIDEOPENWES.bar2.Tampa1.Level3.net [4.34.130.166
    ]
     10    67 ms    67 ms    67 ms  v994.core1.esnet.com [208.38.174.30]
     11    70 ms    69 ms    69 ms  208.38.136.254
     12    69 ms    69 ms    69 ms  222.22.22.22.stabilityhosting.com [222.22.22.22]
    7]
share|improve this question
    
Where is the server physically located and where did the tracert originate from? –  joeqwerty Feb 24 at 21:59
    
In Florida, and originated from Arizona. –  Mike Flynn Feb 24 at 22:07
    
Maybe someone forget to optimize/tune up database after the server restored. Also, do not mix the latency on network with query exec time. How large is the dataset which you're trying to pull ? –  mangia Feb 25 at 2:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.