Database Performance Analyzer

SolarWinds Database Performance Analyzer (DPA) is a cross-platform database performance monitoring and optimization tool designed for database administrators (DBAs), developers, and IT operations teams managing mixed database environments.

Reviewed by 7wData

On this page

Publisher review

SolarWinds Database Performance Analyzer (DPA) is a cross-platform database performance monitoring and optimization tool designed for database administrators (DBAs), developers, and IT operations teams managing mixed database environments. It supports Oracle (including Exadata and EBS), Microsoft SQL Server, Azure SQL Database and Managed Instance, MySQL, DB2, SAP ASE, Aurora, and MariaDB, running on physical, virtual (VMware vSphere), and cloud (Azure, AWS, Google Cloud) infrastructure. DPA is built to answer the question 'Why is my application slow?' by correlating database waits with server resources, enabling root-cause analysis in as few as four clicks. It is particularly suited for organizations with heterogeneous database estates that need a single-pane-of-glass view across platforms without installing agents on each database server.

DPA uses a wait-based response time analysis methodology—monitoring what database sessions are waiting on (e.g., I/O, locks, CPU) rather than just resource utilization. Its machine learning anomaly detection goes beyond traditional fixed-threshold alerts to identify unusual performance patterns automatically. The tool includes expert tuning advisors that pinpoint inefficient workloads aggregated by table, highlighting indexing opportunities with an 'X marks the spot' approach. Blocking analysis reveals the hierarchy of what is blocking what, along with overall impact. PerfStack™ integration lets users correlate database metrics with application, server, storage, hypervisor, and network data from other SolarWinds products. The agent-less architecture imposes a low average overhead of 1% and scales from a few instances to thousands. Historical data analysis supports both real-time and long-term trend identification.

In the database performance monitoring market, DPA competes with tools like Quest Foglight, Redgate, IDERA, Datadog, and Obkio. Compared to these alternatives, DPA is often praised for its breadth of supported database platforms and its unified cross-environment view. However, it is frequently cited as more expensive than some competitors, and its pricing model requires purchasing licenses for each active database instance, which can become costly at scale. Alternatives like Obkio offer a cleaner UI and lower cost for simpler environments, while Datadog provides broader infrastructure monitoring but may lack DPA's deep database-specific tuning features.

The honest trade-offs with DPA center on cost versus depth. The tool's strength is its comprehensive, intelligent analysis for heterogeneous environments, but this comes at a price premium—starting at $142 per database per month—and the per-instance licensing model means costs scale linearly with the number of databases monitored. Users report that the initial setup and tuning of machine learning models can require some effort to avoid false positives. Additionally, while DPA integrates well with other SolarWinds products, organizations not already in the SolarWinds ecosystem may find the PerfStack™ integration less valuable. The agent-less design reduces deployment friction but means some low-level OS metrics are not captured directly by the tool.

Get the AI & data signal, daily.

48k+ subscribers read this every morning. One email, both newsletters. Unsubscribe anytime.

How it works

  1. Cross-platform database monitoring

    Monitors Oracle, SQL Server, MySQL, DB2, SAP ASE, Aurora, MariaDB, and more across physical, virtual, and cloud environments.

  2. Machine learning anomaly detection

    Uses ML to automatically detect performance anomalies beyond traditional fixed-threshold alerts, reducing false positives.

  3. Expert tuning advisors

    Provides indexing recommendations by aggregating inefficient workloads per table, using an 'X marks the spot' analysis.

  4. Blocking and deadlock analysis

    Reveals the hierarchy of blocking sessions and overall impact, helping DBAs resolve contention quickly.

  5. PerfStack™ integration

    Correlates database performance with application, server, storage, hypervisor, and network data from other SolarWinds products.

  6. Agent-less architecture

    No agents required on database servers; scales from a few to thousands of instances with an average overhead of 1%.

  7. Wait-based response time analysis

    Identifies root causes by analyzing what database sessions are waiting on (I/O, locks, CPU) rather than just resource utilization.

Strengths and trade-offs

Strengths

  • Supports 11 database platforms including Oracle Exadata, Azure SQL, and Aurora, providing a single-pane-of-glass view across heterogeneous environments.
  • Machine learning anomaly detection goes beyond static thresholds, automatically identifying unusual patterns without manual baseline configuration.
  • Agent-less deployment with an average overhead of 1% allows scaling from a few instances to thousands without significant performance impact.
  • Blocking analysis shows the full hierarchy of what is blocking what, including overall impact, enabling faster resolution of contention issues.

Trade-offs

  • Pricing starts at $142 per database per month, which is higher than several competitors like Obkio and can become expensive at scale.
  • Requires purchasing licenses for each active database instance, leading to linear cost growth as the environment expands.
  • Initial setup and tuning of machine learning models may require effort to avoid false positives in anomaly detection.
  • PerfStack™ integration is most valuable within the SolarWinds ecosystem; organizations not using other SolarWinds products get limited benefit.

Pricing context

Starts at $142 per database per month; licenses required for each active database instance.

Getting started with Database Performance Analyzer

  1. Sign up for DPA

    Go to the SolarWinds Database Performance Analyzer website and start a free trial or purchase a subscription. Provide your email and organization details to create an account and receive login credentials.

  2. Connect your databases

    Log in to the DPA web console and add each database instance you want to monitor. Enter the hostname, port, and credentials for Oracle, SQL Server, MySQL, or other supported platforms. DPA uses agent-less connections, so no software installation on database servers is needed.

  3. Configure anomaly detection

    In the settings panel, enable machine learning anomaly detection for your databases. Adjust the sensitivity and baseline period to match your workload patterns. This reduces false positives by learning normal behavior over time.

  4. Analyze a performance issue

    Open the dashboard and select a database experiencing slowness. Use the wait-based analysis to view top waits like I/O or locks. Click through the blocking hierarchy to identify the root cause session and resolve the contention.

  5. Schedule regular reports

    Set up automated performance reports to be emailed to your team daily or weekly. Choose metrics such as top waits, anomaly alerts, and tuning recommendations. This keeps stakeholders informed without manual checks.

Frequently Asked Questions

What is SolarWinds Database Performance Analyzer?

SolarWinds Database Performance Analyzer (DPA) is a cross-platform database performance monitoring and optimization tool for DBAs and IT teams. It supports Oracle, SQL Server, MySQL, DB2, SAP ASE, Aurora, and MariaDB across physical, virtual, and cloud environments.

How does DPA identify why an application is slow?

DPA uses wait-based response time analysis to correlate database waits with server resources. It monitors what database sessions are waiting on, such as I/O, locks, or CPU, enabling root-cause analysis in as few as four clicks.

Does DPA require installing agents on each database server?

No, DPA uses an agent-less architecture that imposes a low average overhead of 1%. It scales from a few instances to thousands without requiring agents on each database server, reducing deployment friction.

What databases does SolarWinds DPA support?

DPA supports Oracle including Exadata and EBS, Microsoft SQL Server, Azure SQL Database and Managed Instance, MySQL, DB2, SAP ASE, Aurora, and MariaDB. It runs on physical, virtual, and cloud infrastructure like Azure, AWS, and Google Cloud.

How does DPA's machine learning anomaly detection work?

DPA's machine learning anomaly detection goes beyond fixed-threshold alerts by automatically identifying unusual performance patterns. It reduces false positives and requires some initial setup and tuning to avoid incorrect alerts.

What is the pricing model for SolarWinds DPA?

DPA starts at $142 per database per month, with licenses required for each active database instance. This per-instance pricing leads to linear cost growth as the environment expands, making it more expensive than some competitors at scale.

Alternatives

How Database Performance Analyzer compares

Direct head-to-head against 3 competitors. Picked by 7wData.

This tool

Database Performance Analyzer

Pricing
Starts at $142 per database per month; licenses required for each active database instance.
Target
SolarWinds Database Performance Analyzer (DPA) is a cross-platform database performance monitoring and optimization tool designed for database administrators (DBAs), developers, and IT operations teams managing
Strength
Supports 11 database platforms including Oracle Exadata, Azure SQL, and Aurora, providing a single-pane-of-glass view across heterogeneous environments.
Watch for
Pricing starts at $142 per database per month, which is higher than several competitors like Obkio and can become expensive at scale.

dbWatch Control Center

Pricing
Custom/Contact sales
Target
Enterprise DBAs managing heterogeneous environments
Deployment
On-prem/Cloud
Strength
Agentless architecture for lightweight monitoring
Watch for
Steeper learning curve for non-technical users

Datadog Database Monitoring

Pricing
$70/host/month (add-on to Infrastructure plan)
Target
DevOps teams needing full-stack observability
Deployment
SaaS
Strength
Correlates DB metrics with APM and infrastructure data
Watch for
Cost scales aggressively with host count

Quest Foglight

Pricing
Custom/Contact sales
Target
Large enterprises with complex SQL environments
Deployment
On-prem/Cloud
Strength
Deep SQL Server diagnostic capabilities
Watch for
Resource-intensive deployment requirements

User reviews

No user reviews yet. Be the first to write one.

Sources

Reporting on this tool draws on these publicly available sources.

  1. www.reddit.com
  2. www.trustradius.com
  3. www.dbwatch.com
  4. www.youtube.com
  5. www.solarwinds.com
  6. www.solarwinds.com