Administer > Introduction > Introduction to DPA

Introduction to DPA

You can use SolarWinds Database Performance Analyzer (DPA) to monitor, diagnose, and resolve performance problems for Oracle, SQL Server, MySQL, DB2, Sybase, and Azure SQL databases.

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.

See the following topics to start using DPA:

Understand and apply DPA licenses	DPA license types DPA registration and licensing options for clustered environments Purchase and view DPA licenses Activate DPA licenses Allocate or deallocate DPA licenses Troubleshoot over-allocated DPA licenses Deactivate your DPA licenses
Register the database instances you want to monitor	Database instances DPA can monitor Register multiple database instances Register an Oracle database Register a SQL Server database Register a Sybase database Register a DB2 database Register a MySQL database Register an Amazon RDS for Oracle database Register an Amazon RDS for SQL Server database Register an Amazon RDS for MySQL or Aurora database Register an Azure SQL database Unregister a monitored database instance
Investigate performance issues	Access DPA query or table tuning advisors Use DPA's query performance analysis to find the root cause of performance issues Investigate inefficient queries running against a table Identify blocking sessions and deadlocks with DPA Find and investigate unusually long wait times (anomalies) About anomaly detection in DPA Add an annotation to document a change to the database Name SQL statements
Manage monitored database instances	Update a monitored database instance Stop monitoring a database instance for a period of time DPA troubleshooting tips
Configure DPA alerts and reports	Configure a DPA alert Send SNMP traps from DPA alerts Create a DPA alert group Create and manage DPA contacts and contact groups Create a DPA report group
Link DPA servers together	Set up a Central Server and add remote DPA servers Configure authentication for the DPA Central Server View information from remote servers on the DPA Central Server Advanced configuration for the DPA Central Server
Automate tasks with the DPA REST API	Manage tokens used for authentication to the DPA API Learn about and experiment with the DPA API Examples of using Python scripts to make DPA API calls Examples of using PowerShell scripts to make DPA API calls