Submit a ticketCall us

Training ClassSign up for Network Performance Monitor (NPM) and Scalability instructor-led classes

Attend our instructor-led classes, provided by SolarWinds® Academy, to discuss the more advanced monitoring mechanisms available in NPM as well as how to tune your equipment to optimize its polling capabilities. NPM classes offered:
NPM Custom Monitoring and Polling
Orion Platform Scalability

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA Documentation > DPA 12.0 Administrator Guide

DPA 12.0 Administrator Guide


Last update: August 28, 2018

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

DPA 12.0 Administrator Guide

+ Introduction

Get an overview of DPA features and architecture.

+ Licensing

Learn about license types, licensing options for clustered environments, activating and allocating licenses, and troubleshooting over-allocated licenses.

+ Register a database instance for monitoring

Learn what types of database instances DPA can monitor, how to register each type, or how to unregister an instance you no longer want to monitor.

+ Database instance groups

Learn about monitoring SQL Server AGs, monitoring Oracle CDBs, and creating custom groups.

+ Monitor database instances

The DPA homepage displays a list of the monitored database instances with status and wait time information.

+ Investigate performance issues

DPA uses an approach called wait-based analysis to help you focus on issues that provide the greatest performance improvements. Query advisors and table tuning advisors identify and performance issues and help you find the root cause.

+ DPA user accounts

Create user accounts, assign privileges, and specify how users will log in to DPA.

+ Alerts

DPA alerts give you proactive control of your databases, notifying you of issues before they become problems for your customers.

+ Reports

Use reports to communicate the long-term performance of your databases across your organization. You can capture the results of performance tuning, important database resources, and database trends.

+ Link together separate DPA servers

Use Central Server mode to link separate DPA servers together. This is useful if you want to monitor more than 250 database instances, or if your monitored databases are distributed geographically.

+ Administrative tasks

Learn how to set advanced options and how to stop and start DPA.


Last modified