Home » Product » Usage Scenarios » Deep-dive Application Diagnostics » Database Diagnosis

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 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.

Out-of-the box Sensor Packs for all major database technologies (JDBC, ASP.NET) and 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 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