Acronis Bitdefender Fortinet Microsoft Cisco Duo HPE Adobe Adobe Green Rocket Acronis Bitdefender Fortinet Microsoft Cisco Duo HPE Adobe SolarWinds Green Rocket
⌘K
Database Analysis

Optimize the Performance of Your Databases

Identify slow queries, analyze wait times and receive automated recommendations to improve the performance of any database.

Request Demo View Supported Databases
400+
Days of History
10+
Platforms
60s
Granularity
Compatibility

Supported Databases

DPA works with the leading relational and NoSQL databases, both on-premise and in the cloud.

SQL Server

All versions

Oracle

11g, 12c, 18c, 19c, 21c

MySQL

5.6, 5.7, 8.0, MariaDB

PostgreSQL

9.6 to 15

Amazon Aurora

MySQL and PostgreSQL

Azure SQL

SQL Database, Managed Instance

Google Cloud SQL

MySQL, PostgreSQL, SQL Server

MongoDB

4.0 to 6.0

1

Query Capture

Automatic collection of all executed queries

2

Wait Analysis

Identification of wait times and locks

3

Event Correlation

Linking metrics with changes and events

4

Recommendations

Automatic suggestions for indexes and optimizations

Analysis Flow

Deep Analysis of Queries

DPA analyzes each query and provides detailed information about its performance, execution plan and areas for improvement.

Benefits

Database Performance Analyzer Advantages

Discover how DPA can transform your database performance management.

Quick Problem Identification

Locate slow queries and bottlenecks in seconds, reducing problem resolution time.

Continuous Optimization

Receive automatic recommendations for indexes and configuration adjustments to improve performance.

Multi-platform and Multi-cloud

Monitor on-premise databases, on AWS, Azure or Google Cloud from a single console.

Waits

Pinpoint the Biggest Wait Bottlenecks

Rank wait categories to focus tuning efforts where they matter most.

  • Visual breakdown by query, host and instance
  • Correlation with deployments and configuration changes
  • Historical trends for proactive capacity planning
I/O waits 38%
CPU contention 26%
Locking 20%
Network latency 16%
Playbooks

Optimization Playbooks for DBAs

Apply guided fixes to stabilize performance and prevent regressions.

Index Recommendations

Create or adjust indexes based on query fingerprints.

Execution Plan Insights

Compare plan changes to spot regressions fast.

Query Refactoring

Highlight costly statements and optimize SQL patterns.

Capacity Forecasting

Predict growth and align upgrades with demand.

Outcomes You Can Measure

Reduce MTTR, protect SLAs and keep critical databases fast.

45%
Faster root cause identification
30%
Lower tuning effort
99.9%
SLA compliance
60%
Query performance gains
Specifications

Technical Capabilities

Supported Databases

  • Microsoft SQL Server (all versions)
  • Oracle Database (11g to 21c)
  • MySQL, MariaDB and PostgreSQL
  • Amazon Aurora and RDS
  • Azure SQL and Google Cloud SQL

Analysis Capabilities

  • Query analysis with execution plan
  • Wait time and lock analysis
  • Performance history up to 400 days
  • Smart alerts with dynamic thresholds
  • REST API for integrations

Maximize the Performance of Your Databases

Contact our experts for a personalized DPA demonstration and discover how to optimize your databases.

Request Information