This content has been marked as final. Show 5 replies
What do you want to achieve here?
After having run a load test, you want to retrieve the 90% percentile value from OLT in OpenScript, right?
You can probably record navigation in OLT to display the graph with the 90% percentile and then store the value into a variable.
You cannot get the value from the OLT DB because it is calculated on the fly... Or you can retrieve the list of values from the DB and then calculate the 90% percentile in the java code.... I don't know how to do that.
Thanks a lot for the reply. but how to get the timer values from the DB, i mean, in what tables these values are saved. Because I did not find any such table which store the step execution time in DB.
This is an example of a query to retrieve data timers from the DB.
-- Report Timers par Script
round(stddev(cr.counterval),3) "Std Dev"
FROM olt.sessionrun s,
AND ch.counterhdrid =cr.counterhdrid
AND ch.countername like 'Avg Server Time %'
AND s.sessionname = '&1'
AND ch.instname is NULL
group by s.sessionname, ch.countername, ch.objname, ch.instname
ORDER BY s.sessionname, ch.countername, ch.objname, ch.instname
I've often thought the 90th percentile might be a "nice to have" on the graphs/reports as tests are actually running. Presumably it's just an efficiency thing (why calculate it on-the-fly if you don't really need it?). Presumably most people won't actually NEED it until the test has finished.
Quite often I'll only take a sample of the results anyhow (to avoid the initial ramp-up/cooldown or possibly to avoid any obvious anomalies during the test). e.g. I'll run a 1.5 hour test but take the 'cleanest' hour. Things like the averages and 90th percentile are pretty meaningless during the initial ramp-up anyway.
Thanks JB . I will give it a try, but I am bit worried whether the 90th% percentile time is for complete Script or can we get 90% percentile time per step group?