[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

Application processing accountability in Middle tier application

Our application environment runs on Middletier platform,  that is , Oracle forms on Oracle application server and DB as Oracle.  

When the performance issue reported, To know exactly at which layer it is, by looking which attributes of running application at first place, we can decide issue with Application OR from database side.
0
mansur_mca
Asked:
mansur_mca
  • 3
  • 2
1 Solution
 
Bryan ButlerCommented:
Could you please rephrase your question?  Do you want to find out how to determine performance problems between an application and the database?  
0
 
mansur_mcaAuthor Commented:
yes. If the performance problem is reported, then how to determine performance problems between an application server and the database?  
0
 
mansur_mcaAuthor Commented:
any update on this
0
 
Bryan ButlerCommented:
You would want to monitor the network traffic and also the performance of the server and the database.  Are these on separate boxes?  There are also tools out there that will monitor your DB or app server and tell you exactly what's going on.  The good tools are way pricey, but you may be able to use a trial version.  And application server monitors are out there too.  Is it IIS or Apache or what?  Am I on the right track here?  I'm also thinking your maybe just looking for the basics....check the DB logs, check the server logs, check the network/OS logs.  Or even basic monitoring such as using perfom to check things out.
0
 
mansur_mcaAuthor Commented:
solution provided is quite OK
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now