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 |
What is a rendezvous point?
How a request is routed (request flow) in an n-tier architecture. digramatically explain a basic n-tier architecture.
Where Can i get the Best training on Loadrunner
Hi all, I am new to Load Runner. I have run the load runner and i got analyzed reports/graphs. But i am very much confused about how to analyze those graphs. Can any one help me out this problem?
What are the main Performance issues in JBoss server? And How to do it?
which kind of database counters we use to check the performance of the software and where we can check them?
what is the differance between standard log and extended log?
What is the purpose of a loadrunner transaction?
What are monitors?
When Do u Do LoadTesting and When You do StressTesting? What settings you have to changes for loadtesting and stress testing?
When do you disable log in Virtual User Generator, When do you choose standard and extended logs?
When the loadrunner controller open the winrunner file then what is the location of the winner configuration file?