Introduction to DPA

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

• DPA license requirements and license types

• Purchase and view DPA licenses

• Activate DPA licenses

• Allocate or deallocate DPA licenses

• Register a database instance for monitoring with DPA

Investigate performance issues with DPA.

• 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

• Table tuning best practices

• 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

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

• Configure a DPA Wait Time alert

• Send SNMP traps from DPA alerts

• Create a DPA alert group

• Create or edit a custom email template for DPA alert notifications

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

• Create a DPA report

• Schedule a DPA report for email delivery

• Create a DPA report group

Manage DPA user accounts.

• DPA roles and privileges

• Create a DPA user account and assign privileges

For large or geographically separate environments, 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