This discussion is archived
5 Replies Latest reply: Dec 28, 2012 9:08 AM by OATSExplorer RSS

How to get 90th percentile time from OLT through code in Openscript

OATSExplorer Newbie
Currently Being Moderated
Hi,

I would like to know if there is any way to get the 90th percentile time from OLT report through code in Openscript.

Please kindly let me know.
  • 1. Re: How to get 90th percentile time from OLT through code in Openscript
    834498 Journeyer
    Currently Being Moderated
    Hi Sriram
    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.

    JB
  • 2. Re: How to get 90th percentile time from OLT through code in Openscript
    OATSExplorer Newbie
    Currently Being Moderated
    Hi JB.

    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.
  • 3. Re: How to get 90th percentile time from OLT through code in Openscript
    834498 Journeyer
    Currently Being Moderated
    This is an example of a query to retrieve data timers from the DB.

    -- Report Timers par Script
    SELECT s.sessionname,
    ch.countername,
    ch.objname,
    ch.instname,
    round(min(cr.counterval),3) "Min",
    round(max(cr.counterval),3) "Max",
    round(avg(cr.counterval),3) "Avg",
    round(stddev(cr.counterval),3) "Std Dev"
    FROM olt.sessionrun s,
    olt.counterhdr ch,
    olt.counterrun cr
    WHERE s.sessionrunid=ch.sessionrunid
    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
  • 4. Re: How to get 90th percentile time from OLT through code in Openscript
    IHodgetts Explorer
    Currently Being Moderated
    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.
  • 5. Re: How to get 90th percentile time from OLT through code in Openscript
    OATSExplorer Newbie
    Currently Being Moderated
    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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points