BMC Software, Inc., Confidential and Proprietary Information
Instrumenting and Profiling J2EE Components 9-5
The report is displayed in a report task window. This report shows which
statements respond slowest or are most often called. Using information
from the report, you can start monitoring selected SQL, and can define
alarm thresholds or alerts to be generated if performance degrades to
unacceptable levels.
The most useful information is the SQL call tracing section. This
information shows what objects (web applications, servlets, methods, or
EJBs) are calling the SQL (stack trace). Information contains the calling
sequence of an SQL statement executed from the web application to the
JSP or servlet to EJB. The calling stack trace will only be available form
the Top N Average Response Times.
While you may want to monitor the SQL itself, you may also want to
look more closely at objects identified in the stack trace to determine
how well they are performing, and possibly monitor them as well.
Where to go from here
You can select SQL objects for monitoring (page 9-6), and you can
further investigate and monitor methods and servlets related to your top
SQL.
are response
times too slow?
