Documentation forDatabase Performance Analyzer

Set up a Central Server and add remote 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. You can divide monitoring tasks between different DPA servers.
  • Your monitored databases are distributed geographically. You can install separate DPA servers in each location.

The Central Server collects information from your remote servers and consolidates the data into a single interface.

Each DPA server has its own repository. The Central Server has low overhead and no additional information from other DPA installations is added to its repository database.

Set up a Central Server

  1. Install DPA on a server. This will be your Central Server.
  2. Log in to that instance as an administrator.

  3. From the DPA menu in the upper-right corner, click Options.

  4. Under Administration > Display, click Manage Central.

    Your DPA server should be listed as the Central DPA Server in the list of Registered Servers.

Add remote DPA servers

The user credentials for the Central and remote DPA servers must match. See Configure authentication for the DPA Central Server for more information.

  1. From the DPA menu in the upper-right corner, click Options.

  2. Under Administration > Display, click Manage Central.
  3. Click Add Server.
  4. Enter information about the remote DPA server.

  5. Click Test connection, and click Save.

    A successful test indicates that DPA can communicate with the remote server through the provider host and port. It does not indicate that DPA can authenticate users.

    If the test fails, check the host name in the Server Name field. Does it contain an underscore (_) character? An underscore is not valid for host names. If you cannot rename the host, enter the IP address.

  6. Repeat steps 1 - 4 for the remaining remote DPA servers.

The details of your remote DPA servers are not stored in the repository, but in a file on your Central Server, located here:

DPA-install-dir/iwc/tomcat/ignite_config/iwc/central/RemoteRepositories.json

This is a plain-text JavaScript Object Notation (JSON) file. No sensitive data is stored in this file.