Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

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

DPA 12.1 Administrator Guide

 

Last update: March 12, 2019

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.1 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.

+ Manage monitored 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.

+ Resource metrics in DPA

View resource metrics and set metric thresholds.

+ 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. Reports can capture the results of performance tuning and highlight 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.

+ Automate tasks with the DPA REST API

Use the API to automate tasks such as registering database instances, adding annotations, and allocating licenses.

+ Administrative tasks

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

 

Last modified

Tags

Classifications

Public