This message was deleted.
# _generals
Slackbot
06/04/2023, 9:05 PMThis message was deleted.
a
Amir Joseph Sayes
06/04/2023, 9:10 PM@Rob Zylowski?
r
Rob Zylowski
06/04/2023, 11:45 PMWhy would you want to? You eoukd be making the database work very hard.
a
Amir Joseph Sayes
06/05/2023, 12:04 AMMake sense thanks Rob but am I right the 5 minutes pulled value is basically an average of RTT on the VDA in the last 5 minutes? Or is it a point-in-time every 5 minutes?
Amir Joseph Sayes
06/05/2023, 12:14 AMThe reason behind my question is that the RTT value shown in Director changes every 15 seconds which gives the impression to customers that they can pull this data for the past 24 hours but I think what is being stored is only 5 minutes intervalsā¦ so just wanted to check if OData value is an average or point in time
r
Rob Zylowski
06/05/2023, 1:51 PMSorry had to dig into looking at the data with my script. It looks like we capture a raw datapoint every 5 minutes in the SessionMetrics table. That data is available for 24 hours. So its not a rollup its a datapoint.
a
Amir Joseph Sayes
06/05/2023, 1:58 PMThanks for looking Rob, much appreciated. So if I understand this correctly that datapoint is representative of that very second of capturing meaning if my session suffered a short 1 minute RTT delay in between those captures that delay will not get recorded?
r
Rob Zylowski
06/05/2023, 2:02 PMYes and its about 5 minutes not exactly
Rob Zylowski
06/05/2023, 2:02 PMbut as long as you are looking at all the rtt form the session you woudl be ok
a
Amir Joseph Sayes
06/05/2023, 2:04 PMVery helpful to know- thanks again š»
r
Rob Zylowski
06/05/2023, 2:04 PMYoure welcome