Dear Friends,
One of my company's application is now having performance issue.
It is made in JSP 1.2, Java 1.4, Oracle 8.1.7. It is running for 2 years
but now it is logging out automatically and also user are getting login,
they have take many tries. Mostly this problem is severe at 5 pm.
What should be my approach in solving this issue ?
Thanks
Tanka
> What should be my approach in solving this issue ?
Try to determine why the users are being logged out. Figure out what caused that, etc. until you find the root cause.
If the authors included logging statements, try turning them on. Look for stacktraces. What exactly is your role with regard to the application?
Hi,
if it's only a problem at 5pm, there can be other applications at this time running that are taking up the network resources(if you are in an enterprise, probably you can't help it.)
try these:
1. see the DB response time (by logging time in a logger), they cause a lot of problem.
2. Do not use too much of statements, if they are being used, try using preparedStatements.
3. Are there any other, applications running on the app server?
4. Hope you are using connection pooling to get connections to DB.
5. Isolate your performance bottle neck, try to find out if it is app-server or DB.
6. Performance analysis is a bit hard, try a few performance analysing tools.(if you can afford them, they will give good idea of underlying problems.)
Do followup with results/questions.
Rgds
