Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Database Performance Analyzer (DPA) > Divide existing repositories

Divide existing repositories

Table of contents

Overview

A single DPA server can monitor about 250 database instances. If your server has grown beyond that number of monitored instances, you can split the current DPA server into two servers by using the following steps. The process involves backing up and restoring your current repository to a new one, and then removing half of the instances from each.

Environment

All DPA versions

Steps

  1. Stop DPA monitors and shutdown DPA:
    1. Click Stop All Monitors on the DPA home page and verify all monitors stop.
    2. Shut down the Ignite PI Server Windows service to stop DPA.
  2. Make a backup of the current repository.
    • For a SQL Server repository, use the Backup/Restore tools.
    • For an Oracle repository, consider using export/import or data pump to make the backup.
  3. Restore the backup of the current repository.
    • For SQL Server, restore the backup to a new database in another instance.
    • For Oracle, create a new schema and restore export or data pump info into this new schema.
  4. Create a second DPA server.
    • For Windows you will need to install DPA onto a separate server.
    • For UNIX or Linux, you can use the same server, but create a second install directory. If you do this, you will need to configure that installation to use a different port.
  5. Create a DPA user for the restored database, or use an existing service account.
    • Make sure the new user is mapped to the DPA schema and has access to the new database.
    • Do not make it a SYSADMIN on SQL Server as that will not work properly.
  6. Copy and edit the repo.properties file from the current installation to the new one.
    • This file resides in installDir/iwc/tomcat/ignite_config/idc.
    • Adjust connection information as needed so it connects to the restored database.
  7. Determine which instances will be monitored in each DPA server, and remove the others.
    • To remove the instances, you can use Options > Unregister.
    • If you have many instances, contact Technical Support to get a script to help with this step.
  8. Start the original DPA server and start the monitors
    • Verify the correct instances are present in this installation.
  9. Start the new DPA server and start the monitors.
    • Verify the correct instances are present and the monitors are starting.

 

Last modified
16:35, 21 Dec 2016

Tags

Classifications

Public