How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
Answer / rajat
Follow below mentioned steps in order to execute query
through LR script-
(1) Establish conn with DB
lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "bb",
"lion", "hammer", "", 0, 0, 0);
(2) Enter query
lrd_stmt(Csr1, "select ename from employee where
(sal>=1000)\n", -1, 1, 1, 0);
(3) lrd_bind_col(Csr1, 1, &D21_ENAME, 0);
(4) Execute query
lrd_exec(Csr1, 0, 0, 0, 0);
(5) lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);
(6) lrd_close_cursor(&Csr2, 0);
(7) lrd_close_connection(&Con1, 0, 0);
| Is This Answer Correct ? | 6 Yes | 1 No |
How often you do the load test in your current project?
why do u need a parameterize fields in ur virtual user script ?
In a web server, database and network are all working fine and now, where could be the problem?
In what situation the throughput will decrease even the hits per second increases???
Difference b/w URL and HTML modes in LR?
While the script is running we find some values that may need to be correlated? Is it possible to do manual correlation for those values?
where do you save u r scripts in Load Runner?
What is Perfomance Tuning? where can we use this
Can u plz tell me what r the functions available in load runner and how to write userdefined functions and what are they?
Specific Performance Monitoring counters for, 1. Web Servers (IIS, Apache etc) 2. Application Servers (Weblogic etc) 3. Database Servers a. Oracle Database b. Sybase c. SQL Server d. DB2
How many vusers are required for load testing?
How to schedule a scenario?