Loading...

Database Performance

Measure & Compare

Identify performance issues before they affect your customers

Continuous improvements

Compare database performance in Production environments periodically and in Performance Test environments before every release. Analyze changes in database utilization and application workload. Fix potential issues and improve performance. Simplify the process with XDBTIME tools.

1. Compare

2. Analyze

3. Improve

Explain Database Time

Xdbtime report

Is designed to compare Database performance metrics visually in a simple way. Graphical representation minimizes the time required to analyze the report. It starts from the high-level metrics like Database time and allows to go into details to explain changes. SQLs can be classified into groups, this allows visually correlate changes in different SQL metrics. Conditional formatting attracts your attention to the main drivers. It does not require DBA knowledge to review database performance reports and to do an initial analysis.

Visualization

Take advantage of comparing data in form of charts using the powerful D3JS library. Spend minimal time in report review. Focus your time on analysis of performance issues and on performance improvements.

From general to particular

Start your analysis from high-level metrics like Database time. Go into details to understand changes in CPU and wait time. Correlate differences in wait events with SQL statistics and application workload.

All in one

XDBTIME report contains many sections which can help you to explain changes in performance. Starting from database time you can deep into wait classes and events, active session history, or system events. SQL statistics can be compared by different metrics like elapsed time, executions, disk reads, etc.

Classify SQLs

All SQLs are divided into three main groups when performance is compared: aged-out, unclassified and new. Additionally, SQLs can be classified into custom groups. Just link SQLs with custom groups. Comparing SQL statistics by groups can show you which group of SQLs affected performance.

Highlight changes

Conditional formatting can focus your attention on key drivers in performance changes. It is based on maximum positive / minimum negative change in particular SQL metric. All differences are colored as a gradient from negative to a positive value. You can easily focus on a few key driver SQLs in a list of TOP 20.

Simple

Whether you are a developer or a tester, you can do an initial review of the report on your own. You do not need to ask a DBA to check performance after every test run. DBAs can focus their time on more important things. Ask DBA for help only if you see issues in database performance.

Devops

Automation

Gather raw database performance metrics automatically after every performance test run. Just add one step to your performance test pipeline. Compare database performance when required - select two test runs and generate a comparison report using xdbtime.

Strategy

Do initial detailed production database performance review. Analyze and classify main SQLs, reduce resource consumption and minimize waits. Review production database performance weekly: create a pipeline to generate xdbtime reports for production databases. Review reports, explain changes in performance, prevent performance issues that can affect your customers.

Databases

Xdbtime tools work with MySQL and Oracle databases. MySQL 5.7 and 8.0 are supported (including AWS Aurora MySQL). Oracle 12c, 18c, 19c versions, and XE/SE/EE software editions are supported. For Enterprise Editions with Diagnostics Pack licenses - reports are based on AWR data. For Express/Standard editions - xdbtime tools are used to capture snapshots.



Download xdbtime

Checkout xdbtime project on GitHub ( or download ). Open-source version includes period Performance Comparison report for Oracle databases and Performance Status report for MySQL databases.

xdbtime pro tools are dedicated for enterprises and include implementation and set-up of processes to compare database performance on test and production environments. With pro version you can additionally compare performance of two different time periods on MySQL databases, collect and compare performance metrics from MySQL and Oracle databases. We can help with initial database performance analysis. xdbtime can be customized for your needs. We are happy to answer all your questions about xdbtime products. Just leave us a detailed message below and we'll get back to you.

All the fields are required