Analysis: Extract "Test summary" into excel

[Suresh Babu]

Hi All,

Is there any way we can extract the "Test summary" into an excel sheet automatically without opening the analysis file

As the analysis file is taking almost 2hrs to open for our tests

It would be most helpful for us if we automate this process.

Thanks

Regards,
P. Suresh Babu

[James Pulley]

The event files have not been readable on a flat basis since about
version 8 of Loadrunner, so you are pretty much going to have to bring
them into analysis. Some things which you can do to speed up
analysis.

(1) Have your results dumped to an empty local partition if using MS
Access data files. Remember, two of the primary bottlenecks for
performance are disk and network. By minimizing the influence of
both you will speed up the ingest into analysis.
(2) Make sure your temp files for windows (if using MS Access MDB
files which is the default) are on a very fast and very clean drive.
(see (1) above for explanation)
(3) Use Microsoft SQL Server (or MSDE) as the backend for the data
instead of the default MS Access DB model
(4) Don't run analysis immediately after the test. Instead move to
the fastest machine you have with the most available RAM (This is a 32
bit app so over 4GB doesn't help you) and run the analysis there.
(5) Don't run analysis via remote desktop.

If you run at the end of the test and place automatically into a MSSQL
Data store then you could also automate reporting via cognos or
something similar at the conclusion of the test, or run Analysis with
your template dumping the results to a web site.

'Pulley

[Suresh Babu]

Thanks for your valuable suggestions James.

We are running in the fastest machine we have but the problem is we are running it remotely. Will try to run it in our local machines.

Actually as soon as the test completes we require summary data such as "Transaction Names", "90%", "Avg%" response time, "Pass" and "Failure" rates only on first hand basis.

Secondly, Is it possilbe to extract the only summary results i.e ("Transaction Names", "90%", "Avg%" response time, "Pass" and "Failure" rates) after configuring SQL Server/MSDE in analysis that too without opening the Analaysis file.

Regards,

P. Suresh Babu

--
You received this message because you are subscribed to the Google "LoadRunner" group.
To post to this group, send email to LR-Loa...@googlegroups.com
To unsubscribe from this group, send email to
LR-LoadRunne...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/LR-LoadRunner?hl=en

[Gaurav Mishra]

i dnt know about controller .......... one can do it by performance centre

--
Thankx and Regards
Gaurav Mishra

[James Pulley]

Analysis will push the data into MSSQL or MSDE. So, you will need to
open the analysis to have the data converted from the .LRR (LoadRunner
Results) event file format to the .LRA (LoadRunner Analysis) format
for storage inside of either a Microsoft Access (MDB) formatted
database or MSSQL Server Database.

if your results are stored on a remote drive then you are basically
going to be hosed from a performance perspective. Zip the lrr
results directory, copy it over as a single file and then decompress
and run against the analysis. You can construct a template that only
has the top level report in it so all of the other graphs dont have to
be generated as the generation of these graphs can take an awfully
long time. On a very embarrassing note the Analysis database doesn't
have any foreign key or index definitions so the database engine has
to work twice as hard and all of the report generation requires
enormous amounts of table scan activity for the generation of summary
data for each transaction. If HP would just add indexes on the [...
meter] tables for the transaction and other event names then it would
speed up the generation and redray of data significantly without
having to re-engineer the front end. HP, are you listening.....this
has been a problem since LoadRunner 6.5 and the very first release of
the Analysis tool for large results sets.

Prior to LoadRunner version 8 the .lrr event files were flat files
with a .eve extension. It was faily easy to write your own parser of
the results sets to do exactly what you want to do. Since LoadRunner
version 8 the event file format has changed, going to an undocumented
record structure format which is also compressed for transfer back
across the network at the end of the test. In short, now its not open
for extracting the transactional data yourself for a quick summary, or
in my case using a completely different analytical engine.

'Pulley
http://www.loadrunnerbythehour.com/PricingMatrix

> >http://groups.google.com/group/LR-LoadRunner?hl=en- Hide quoted text -
>
> - Show quoted text -

[Suresh Babu]

Thanks James, that was really helpful. 

But the sad part is we could not cut down the time to extract the summary results.

Thank you