Using JDBInsight
Once you have setup your database drivers, you can begin
analyzing your applications. JDBInsight will track a swath of
heuristics, and allow you to view them in four basic views.
Additionally, JDBInsight allows for tracing information,
creating customized views and utilizing a command-based console.
Let's take a look at the details of using JDBInsight.
Metrics
One thing to remember about JDBInsight is that it only tracks
calls from within the JDBC API. This is different from other
profilers that track all calls, but doing so allows JDBInsight
to maintain a low overhead and focus on the database/application
bottlenecks. That said, a JVM profiler is included which can be
used to trace JDBC method calls or entire transactions in terms
of thread usage. If entire transactions are monitored, they can
include non-JDBC calls, thus allowing for a somewhat expanded
profiling methodology.
To truly understand how JDBInsight breaks down performance data,
I strongly recommend visiting their web site. The scope of it is
beyond the context of this review. However, suffice to say that
it takes a granular approach that will allow developers and
administrators to really breakdown their analysis.
Transaction Perspective
The transaction perspective allows you to view performance
results at the transaction level, this can be crucial as you
will be able to view the time taken for the entire transaction,
thus analyzing the results of using certain persistence
methodologies (such as Container Managed Beans), as well as see
the sub-transactions in a call stack and thus determining what
aspects of a transaction are taking the greatest amount of time
to process. (Note: Figure 1 from previous shows this view.)
Resources Perspective
The resources perspective is basically for tracking down
resource leaks caused by unclosed JDB resource objects (such as
connections, resultsets and statements). This perspective will
show counter information for the creation, closure and also
unreferenced resource objects. See Figure 2.
SQL Perspective
The SQL perspective will allow you to track the specific SQL
statements in your applications. What's really cool about this
profile is that you can see the results of poorly executing SQL
code, AND also see where your JDBC driver may be performing CPU-
intensive activity on certain calls. See Figure 3.
Calls Perspective
The calls perspective is a visual representation of all the
calls that are being monitored by JDBInsight. It will break the
application into partitions: presentation layer, process,
presentation and database. It is a nice way to view an
application, and the interactive presentation allows you to view
each piece, it's performance and relationship to the other
pieces.
New on the Java Boutique:
New Review:
Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling
API boasts simplicity, ease-of-integration, a well-rounded feature
set, and it's free!
New Applet:
Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA
sequences into three useful formats.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.
