This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Performance Issue on a application

 
Tanka Banerjee
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13074
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 116
Eclipse IDE Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Virag Saksena
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Rahul Toaikani
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tankya,

Was it resolved? Any updates?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic