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 |
How to prepare test data to use in Load runner.
How do you report a bug when it is found in perfomance testing using Load Runner
Does caching have a negative effect on your load testing results?
What kind of problem can we face regarding hardware, software, network and memory bottleneck during the performance test?
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?
what is the meening of performance cente and what is the need ?
what is loadrunner?
what r the client requirements? when u r running the script in Vugen?
which kind of database counters we use to check the performance of the software and where we can check them?
When the rendezvous point is insert?
Throughput ?
how to handle the dynamic left and right boundaries are numeric