Travel Time = Infrastructure Quality
DanielHeth 270004EPS3 Visits (1943)
Have you ever wanted to measure the quality of your infrastructure? Perhaps you'd like to know the time it takes for your endpoints to respond to questions and for the data to make it into the database?
Well, now you can. One of our engineers, Aram, has come up with a simple SQL statement to provide what we are calling "Travel Time".
Travel Time is the average time it takes for all of your endpoints to answer a question, in this case "Last Report Time", and insert that answer into the database. Using this value can give you a nice average measurement of your Relay infrastructure design and the performance of the FillDB service running on your root server.
Use the following SQL statement to determine this value:
NOTE: You will need to modify the statement slightly by configuring your SiteID value for your specific deployment. This can be found by opening the QuestionResults table. The first column contains your SiteID. Update the above sql command and you're good.