How did you find database related issues?
Answers were Sorted based on User's Feedback
Answer / dinesh gawande
If you are using Oracle as database: Oracle comes with a
utility called 'Statspack'. Using statspack you can
identify time/cpu consuming queries, no of hard parses,
queries causing bottlenecks, sequential reads,wait events,
buffer pool advisory, IO statistics and many more things.
When ther is load on the database, generate some statspack
reports and then analyse them. You will get to know/solve
most of the oracle db related issues from statspack report.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / anaz
By Using Database Monitors and DB Resource graph will give
the information for DB
| Is This Answer Correct ? | 4 Yes | 0 No |
In what situation would u want to parameterize a text verification check ?
how can i capture the elapsed time of a scenario in a script?
What is a difference between pacing and think time?
What is the relation between Response Time and Throughput?
what is remote performance monitering?
What is Injector in Loadrunner?
How did you plan the Load? What are the Criteria?
Using LR recorded the HTML/HTTP Protocol Script of an application. But after record we get to know that the script is not generated. What is the Root Cause of it? Why the scripts are not recorded? Note: 1.Here the application behaves well and good 2.No issues in Protocol setup
How to handle the encrypted values in correlation. please send me example with explanation
what r the major concepts in C are very much used in load run script?
What is Ramp up? How do you set this?
How to calculate TPS in LR and Jmeter? Suppose I need to carry out test for 1hr duration with 10 VU and i need to achieve 5000 transactions. What should be the iteration of a single user to achieve this ?