For a scenario I need load runner to give me a report in a specific format.

Hi All,
Scenario: I have an excel sheet with 1000 SQLs. 1 SQL in each row. I want load runner to pick this SQLs and run it with different users (say 3 users at a time) simultaneously. For example, User1 picks SQL1, User2 picks SQL2 & User3 picks SQL3. Now the user which finishes first will pick the next SQL, say for example User2 finished first, then it will pick SQL4 and so on till all SQLs are exhausted.
Report: In the final report I need the following:
For each SQL - User which executed the SQL, SQL, Start Time, End Time, Response Time.
For all SQLs (overall): CPU Usage, Memory Usage, Disk Usage of the Server.
The report format can be anything, txt or excel.
Thanks,
Alok

Questions by alok1001

Showing Answers 1 - 2 of 2 Answers

pardhasaradhi

  • Mar 6th, 2016
 

As per knowledge in LR, LR will only support CSV format and .txt format files.

1. If you placed 1000 SQL queries in txt file or else CSV file in one date file with the parameter settings as Unique, Each iteration, Abort vuser.

2. Place the Usernames in to one more dat file.

3. Divide the SQL queries based on the available users and allocate SQL queries per user in parameter settings.

Hope this will give the results as per your scenario.

  Was this answer useful?  Yes

shashank

  • Aug 21st, 2018
 

you could keep parameter settings as
Select next row : Unique
update value : Each Iteration
When Out of values : Abort Vuser
and you can print the username , iteration number and sql parameters using lr_output message , which gives details about which user used which data

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions