Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Performance and the fly likes Performance Issue on a application Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Performance
Bookmark "Performance Issue on a application " Watch "Performance Issue on a application " New topic
Author

Performance Issue on a application

Tanka Banerjee
Ranch Hand

Joined: Aug 16, 2006
Posts: 64
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
William Brogden
Author and all-around good cowpoke
Rancher

Joined: Mar 22, 2000
Posts: 12760
    
    5
Naturally my first question would be "what has changed?" - is the user load bigger, has the network configuration changed?

My next question would be "what monitoring capability do you have?" Can you watch the CPU load, disk activity, memory use, network traffic, etc. etc. to see what changes around 5pm.

Then there are always the hardware related possibilities - have the disk(s) been defragmented.

Bill
Chris Beckey
Ranch Hand

Joined: Jun 09, 2006
Posts: 116

In addition to the previous suggestions, look at the database. If memory serves correct Oracle auto-optimization was implemented or significantly improved after version 8 so the execution plans could be sub-optimal.
prasad kulkarni
Ranch Hand

Joined: Mar 19, 2006
Posts: 66
1] As the application is running from last 2 yrs, the Database size might have increased & so your sql queries are taking lot of time to access the records from database. Try to optimise the sql queries.
2] At 5 pm , the user-load might be increasing. Please verify.
3] There is possiblity that , in your application there might be a code-cache or any other cache, which might be scheduled to refresh at 5 pm everyday. Please verify this also.


scjp, scwcd
Virag Saksena
Ranch Hand

Joined: Nov 27, 2005
Posts: 71
Tanka,
What application server are you using ?
Download Auptyma's Java Application Monitor, deploy it and observe the JVMs in question at 5 PM ? What do you see happening ? Do you see a lot of requests waiting for a lock ? Or are folks waiting for a database wait or network wait ?

It will tell you where the bottleneck is happening.

Regards,

Virag


<a href="http://www.auptyma.com" target="_blank" rel="nofollow">The Peak of Performance</a>
Rahul Toaikani
Ranch Hand

Joined: Feb 14, 2007
Posts: 36
Tankya,

Was it resolved? Any updates?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Performance Issue on a application
 
Similar Threads
Comments on this design
Logging inside Context Listener
how to increase speed of application in weblogic8.1 and sqlserver2005
Performance Issue on a application
Performance optimization