Timeline for Slow remote SELECT statement due to long "client processing time", but fast locally
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S May 28, 2013 at 17:00 | history | suggested | Taryn | CC BY-SA 3.0 |
Updated link to remove link shortener
|
| May 28, 2013 at 15:49 | review | Suggested edits | |||
| S May 28, 2013 at 17:00 | |||||
| May 1, 2012 at 16:04 | comment | added | jgardner04 | There could be a mismatch between the network card speed and the switch port. Have you engaged your network team to look at it from the switch side? | |
| May 1, 2012 at 16:00 | comment | added | FranticRock | After monitoring these stats in Perfmon, i noticed a few things. The total bytes/sec never goes up over 700K/s on any of the network cards. Even if I'm running a query that requests megabytes of data, this number stays at around 500K/sec. Our bandwidth is 100 MBPS, and we are not even getting to 1% usage of it. I am thinking there should be a limit configured somewhere that is forcing down the size of the packets, or limiting the transfer rate. The hardware interrupts / sec are at 700-2000. Output queue is empty. Network card usage peaks at about 4% at the highest. | |
| May 1, 2012 at 13:54 | history | answered | jgardner04 | CC BY-SA 3.0 |