 Home > Product > Usage Scenarios > Database Diagnosis
Database Diagnosis
PurePath showing all SQL calls executed by a single dedicated transaction
Nearly every application today connects to a database. However, in many cases the
database connection turns out to be the primary application performance bottleneck.
Often it’s not just a set of certain SQL calls that are inefficient and thus require
tuning, but it’s the surprisingly high number of database calls (1000 and greater)
that a single transaction executes causing the performance issue.
Inadequate use of O/R mapping frameworks like Hibernate or EJB container managed
persistence make such issues quite frequent. Plus, inadequately scaled connections
pools may dramatically reduce application performance due to long wait times.
dynaTrace Diagnostics with its PurePath Technology enables you to quickly resolve
those database performance bottlenecks as it allows you to correlate database statements
to single transaction executions. As a result you exactly see which database statements
have been executed by a specific transaction. Capturing bind values even provides
you with the ability to find out the performance impact of method parameters such
as data provided through user input. Correlating this transactional performance
data about code–level execution with information about the database connection pool
provides all the required information to optimize database performance.
PurePath showing the call tree including the SQL execution of the transaction
Diff view showing the success of database performance tuning
Out-of-the box Sensor Packs for all major database technologies (JDBC, ASP.NET)
and all database vendors (DB2, Oracle, SQL Server) as well as persistence frameworks
like Hibernate enables you to identify the performance of your database code without
any configuration within minutes.
Bottom line, dynaTrace Diagnostics enables you to:
- Identify inefficient database queries
- Uncover poor application design leading to an excessive number of database queries
- Understand the dynamic behaviour of persistence frameworks
- Tune connection pool parameters to achieve optimal performance
- Evaluate database access tuning effects immediately
Read more about...
|