Register a database instance for monitoring with DPA

You must register each database instance that you want to monitor with DPA. Registration enables DPA to connect to the instance and monitor database activity.

For more information about what types of database instances you can monitor, see Database instances DPA can monitor. See the following sections for information about how to discover unmonitored database instances in your environment and options for registering them.

If the database instance runs on a virtual machine (VM), you can monitor VM performance data by registering the VMware ESX/ESXi Host or vCenter Server that the VM runs on.

For the first two hours after you register the instance, data is shown only on the home page. After two hours, all DPA pages are populated.

Discover database instances

Use Database Discovery to automatically find database instances on your network that are not currently registered for monitoring. Database Discovery helps you ensure that all high-value databases are monitored, and it speeds the process of registering instances by prepopulating fields in the registration wizard.

Register individual instances with a wizard

To register a single database instance for monitoring using a wizard, select the type you want to register:

• Self-Managed:

  • Oracle
  • Microsoft SQL Server
  • SAP Sybase ASE
  • Db2
  • MySQL or Percona
  • MariaDB
  • PostgreSQL or EDB Postgres

• Amazon RDS:

  • Amazon RDS for Oracle
  • Amazon RDS for SQL Server
  • Amazon RDS for MySQL
  • Amazon RDS for MariaDB
  • Amazon RDS for PostgreSQL

• Amazon Aurora:

  • MySQL-compatible Aurora
  • PostgreSQL-compatible Aurora

• Azure:

  • Azure SQL DB
  • Azure SQL Managed Instance
  • Azure Database for PostgreSQL
  • Azure Database for MySQL
  • Azure Database for MariaDB

• Google Cloud Platform:

  • PostgreSQL
  • SQL Server
  • MySQL

Register multiple instances with the mass registration feature

If you are monitoring a large number of database instances, use the DPA mass registration feature to quickly register multiple databases.

Automate registration with the API

You can register database instances using scripts that call the DPA API.