How is the DB latency determined in the performance widget?
I've noticed that the latency reported by the performance widget does often not reflect the same results as the ping utility. Often times the latency is reported higher in the widget while pings between the app and DB server are 1ms or less. Does the performance widget use a certain size packet that is different than the default OS ping packet?
Comments
Donald Nong
Dec 07 '16, 7:36 p.m.Hi Ben, I recall reading somewhere that the said latency is measured by acquiring a connection and run a simple query, so it can be much higher than "ping". I cannot find the reference now or maybe I'm just imagining things. :-)
Oh...maybe we can enable SQL tracing and see if the widget does the thing I mention above.