[jboss-user] [Performance Tuning] - Monitoring Servlets and JDBC

[florentine]

florentine [https://community.jboss.org/people/florentine] created the discussion

"Monitoring Servlets and JDBC"

To view the discussion, visit: https://community.jboss.org/message/818357#818357

--------------------------------------------------------------
Hello,
I'm new to JBoss and I am trying to get some measurement data for a research project.
I am running JBoss 4.2.2.GA and I'm trying to understand how I can measure how much time Jboss takes to respond to a servlet request.
In particular, I would like to measure the following:
1. overhead time for JBoss handling the request/response.
2. computation time for the execution of the servlet itself
3. time spent waiting for the database query. I'm using a Hibernate/JDBC architecture.

I saw that the web-console is giving some measures like the overall aggregated processing time and the number of requests, but I couldn't find anything about the connection to the db.


Thanks a lot for any help and/or suggestion!

Filippo
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/818357#818357]

Start a new discussion in Performance Tuning at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078]

[Wolf-Dieter Fink]

Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion

"Re: Monitoring Servlets and JDBC"

To view the discussion, visit: https://community.jboss.org/message/818947#818947

--------------------------------------------------------------
The only way I know is to wrap the jdbc connection class to monitor it.
But most I'vw e seen is to calculate that inside the appcode.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/818947#818947]

Start a new discussion in Performance Tuning at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078]

[florentine]

florentine [https://community.jboss.org/people/florentine] created the discussion

"Re: Monitoring Servlets and JDBC"

To view the discussion, visit: https://community.jboss.org/message/827575#827575

--------------------------------------------------------------
I was able to solve the problem by using the log4jdbc logger ( https://code.google.com/p/log4jdbc/ https://code.google.com/p/log4jdbc/)
It incercepts all the jdbc calls, it takes their roundrip time and it writes one log entry with the cumulative time.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/827575#827575]

Start a new discussion in Performance Tuning at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2078]