BMC Software, Inc., Confidential and Proprietary Information
Instrumenting and Profiling J2EE Components 9-3
Using Instrumentation to Identify and Monitor Most Critical SQL Objects
By using the instrumentation features of PATROL for BEA WebLogic,
you can generate a report showing which SQL objects are most
expensive in your environment and you can monitor their performance.
Once you know which SQL objects are most critical, and you identify
their associated DBURLs, you can also make modifications to your
WebLogic configuration to optimize performance. For example, if you
notice a pattern of slow performance from a particular DBURL, you may
want to look at components that could affect its performance, such as the
number of connections in its associated JDBC pool, and perhaps increase
the maximum pool size to reduce the likelihood of waiters.
run Top SQL report
to find critical SQL
(page 9-4)
monitor most
crictical SQL
(page 9-6)
