Documentation forDatabase Performance Analyzer

Introduction to DPA

You can use Database Performance Analyzer (DPA) to monitor, diagnose, and resolve performance problems for many types of database instances, both self-managed and in the cloud.

DPA has agentless architecture and uses wait-based analytics for extended database monitoring. DPA uses less than one percent of resources on production systems.

Get a walk-through of DPA functionality from the DPA Getting Started Guide.

Start monitoring database instances

Get the licenses you need, and then register the databases you want to monitor.

Manage DPA user accounts

Investigate performance issues

Use DPA to investigate queries with long wait times, inefficient queries and the tables they run against, and anomalies (unusually long wait times).

Search for a SQL statement

Do you want to see DPA's query performance analysis of a SQL statement that does not show up in the Trends charts? You can search for it based on what you know, such as when it ran, the application, or even part of the SQL text.

Configure alerts and reports

Use alerts to become aware of issues and address them proactively before they affect end users.

Use reports to identify database trends, track the results of your performance tuning, and communicate those results to others.

Link DPA servers together

For large or geographically separate environments, link DPA servers together.

Use the DPA REST API

Automate tasks with the DPA REST API.