I've been asked a question during recent interview that goes like:
In a Java EE app, when load increases its performance goes down, and at some point application stops responding.
What are the steps you'll take to figure out the root cause of this problem?
I had some answers in mind like:
- I will ensure application is using Connection pool
- SQLs are fine tuned
- Session is not getting loaded heaviliy
However the interviewer was not convinced, and he later asked: How will you figure out which part of the application is exactly causing this problem? Will you use any tool or something? I thought for a moment about Profiler, but was not too sure.
Need some help on this?