5 Replies Latest reply: Dec 28, 2012 11:08 AM by 878316 RSS

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

    878316
      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
          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
            878316
            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
              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
                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
                  878316
                  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?