Documentation forDatabase Performance Analyzer

Set up a Central Server and add remote DPA servers

Use Central Server mode to link separate DPA servers together. Examples of why you might want to do this include:

  • The infrastructure resources supporting DPA (for example, storage availability, I/O throughput, RAM, and CPU) reach capacity as the volume of queries being analyzed increases.

  • Your monitored instances are distributed geographically, and the network lag time to distant instances is high. You can install separate DPA servers in each location.

  • You want to enable separate teams or business units to manage their subset of database instances.

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 JSON file. No sensitive data is stored in this file.