Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Database Performance Analyzer (DPA) > Configure failover for the DPA server

Configure failover for the DPA server

Recommended configuration

SolarWinds recommends hosting DPA in a virtualized infrastructure. Virtual hosting increases hardware fault tolerance and makes the DPA deployment less dependent on physical hardware.

Alternate configuration: Cluster failover

If you have a cluster environment, you can configure DPA for continuous monitoring during an outage or failover.


  • Host the repository database in a SQL Server Active/Passive Cluster or Oracle Real Application Clusters (RAC).
  • Host the DPA server on the same cluster as the shared storage.
  • The cluster must be set up with shared storage, accessible to any node in the cluster, and a virtual IP/DNS alias for its clients.

The diagram below depicts a SQL Server Active/Passive Cluster housing the DPA repository:


To implement DPA in this configuration:

  1. Install DPA on the active node on shared storage. This creates the DPA service on the active node.
  2. Create an identical service on one or more secondary nodes.
  3. Configure the failover response. The cluster management should:
    1. Stop the service on the primary node.
    2. Failover the shared storage and virtual IP.
    3. Start the service on the secondary node.
  4. Configure the failback response to do the reverse.

With Oracle RAC, the above DPA software configuration can be used if the Cluster shares disks to house the DPA software. Since all nodes are active in an Oracle RAC configuration, you should configure DPA to use the 'Shared or Load Balanced'  connect string to the Repository.


Last modified