J2EE Web Transaction Agent- response time

Dear JAMon experts,

First of all, i have to say that your monitoring solutions is one of the greatest monitoring tools I found so far! The fine-granularity of monitoring at different levels is one of the key competitive advantages.

I went through the documentation and I was unable to precisely decide if it can server my requirements. You'd be able to quickly help answering this need.

My application architecture is (Load balancer + JBoss 3.2.3 + MySQL 5.0.19). I use J2sdk1.4.2.19 and my application uses Java servlets.

I want to log the processing for each request at the JBoss server as well as the the corresponding MySQL processing time of each request. I need to get these times separately. For example:

If we have 3 requests; search for item, checkout, and login

I want to log data such as the following:

Request JBoss P.T MySQL P.T (*P.T.: Processing Time)

search for time 85 ms 150 ms

checkout 50 ms 20 ms

I want to log such information for each request received by JBoss (along with request details- e.g., URL, request start and end time, response status, etc)

I found ( Monitor J2EE Web Transaction & J2EE Web Transaction Agent) to be useful for my case. However, I'have some inquiries:

Does the J2EE web transaction agent measure the queuing and thread allocation time for each request?

Where does the collected measurement data are stored? Can I read the data from a log file instead of visually displaying it? I need all measurement data (not the statistics over period of time)

Can I only install and use the J2EE Web Transaction Agent only to collect response time for each request?

Every how long measurement data is collected- per-request, every predefined period of time, or?

I look forward to hearing from you so I can proceed with the J2EE Web Transaction Agent if it suits my requirements

Separate replies can be sent here as well : noor-k83(at)live.com

Thanks a lot