SolarWinds uses cookies on our websites to facilitate and improve your online experience. By continuing to use our website, you consent to our use of cookies. For further details on cookies, please see our cookies policy.

The SolarWinds Orion Installer is an all-in-one application for installations and upgrades. You use one installer to install or upgrade multiple Orion Platform products and install or upgrade Additional Polling Engines, Additional Web Servers, and High Availability Servers.

Split out DPA monitoring by database within an instance

Table of contents

Overview

Many times when multiple databases have been combined into one instance, the DBA would like a view of performance by each individual database or at least a segragated view of performance into the 2-3 larger databases. To accomplish this, DPA has the ability to register an instance multiple times, but then filter out/in databases to be monitored. For example, you could register Instance I1 3 times. The first registration can be configured to collect performance information from only the PROD database. The second registration could be configured to collect data from the DYNAMIC database and finally the 3rd could collect data from all other databases except for PROD and DYNAMIC.

Notes:

DPA puts less than 1% overhead on each instance it monitors, but when an instance is registered multiple times as described above, the DPA monitoring will be done 3 times per instance. The overhead would be around 3 times more than simply registering an instance once.

Each registered instance requires a license.

Environment

DPA, all versions

Steps

To accomplish the scenario described above where the I1 instance is registered three times, complete the following tasks.

Configure DPA to Allow Multiple Registrations of the Same Instance

Modify a system property to allow DPA to register an instance more than once. This is a one time configuration and it is suggested to set this parameter back to false after registering an instance multiple times. This will prevent accidental registration of the same instance more than once when it is not wanted.

Open the system.propertiesfile in a text editor. This file is located on the DPA server in:C:\Program Files\SolarWinds\DPA\iwc\tomcat\ignite_config\idc

Add the following parameter:

# Allow instance to be registered more than once. This is good if someone wants# to register one database at a time in the same instancecom.confio.idc.wizard.allowDuplicateDatabaseRegistration=true

Restart the Ignite PI Server service.

Register the Instance Multiple Times

Modify the currently registered instance. This assumes the I1 instance is already registered once. If not, register it now.

Restart the DPA monitor for this instance. It should be listed on the DPA home page with the new name.

Now you can register the instance again and go through Steps 1-5 above to have it monitor a different subset of databases. When registering, make sure to choose “No” for creating the monitoring user, as it is already there. You could also create multiple users, one for each registration of the instance. This might make troubleshooting easier.