Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

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

Tags

Classifications

Public