Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.1 Administrator Guide > DPA licensing > Registration and licensing options for clustered environments

Registration and licensing options for clustered environments

Created by Melanie Boyd, last modified by Melanie Boyd on Nov 07, 2017

Views: 17 Votes: 0 Revisions: 2

To get the maximum value from DPA, SolarWinds recommends the following options for registering and licensing SQL Server Availability Groups (AGs) and Oracle Real Application Clusters (RACs).

Every environment is different, so talk with your SolarWinds representative for other options.

SQL Server AGs

You can register SQL Server availability groups (AGs) using either of the following options:

  • Register each SQL Server instance in the cluster
  • Register the AG listener

Register each SQL Server instance in the cluster

If there are multiple AGs in the cluster, this option is recommended because it ensures that DPA does not monitor the same instance more than once. DPA monitors all activity on each instance, including primary and secondary AG activity.

With this option, DPA does not follow AGs when they fail over. Monitoring all instances in the cluster ensures that you see all activity when AG failovers occur.

Register the AG listener

Use this option if you want to monitor activity on the instance that contains the primary replica of an AG. When the AG fails over, DPA follows the listener and begins monitoring the SQL Server instance that now acts as the AG's primary replica.

SolarWinds recommends registering only one listener per cluster unless you can ensure that no instance in the cluster will act as the primary replica for multiple AGs. If you register multiple listeners and the same instance acts as the primary replica for more than one of the AGs, DPA monitors that instance multiple times. Duplicate monitoring is not recommended.

SQL Server logins are not automatically replicated. To enable DPA to continue monitoring after a failover, you must manually create the DPA login on all instances in the cluster that can act as the primary replica for the AG.

Oracle RACs

For Oracle RAC (Real Application Clusters), register every instance in the cluster. Do not register the virtual IP that distributes load across the RAC instances.

For Oracle RAC with Data Guard, register both environments but only monitor the primary one. If a failover occurs, simply reassign the licenses to the instances in the secondary RAC environment.

When you register a RAC instance, there may be listener configuration changes needed if you are not listening on the physical IP address. SolarWinds recommends:

  • If you are registering pluggable databases (PDBs) on a RAC instance, consider registering with the physical IP address of the host.
  • If you are registering a non-PDB RAC instance, consider registering with the SID.
  • If you are using the Service Name, consider using the physical IP address of the host. Do not use the virtual IP address (VIP) or the Oracle Single Client Access Name (SCAN) IP address.

Learn more

For more information about licensing, see the following topics:

Last modified

Tags

Classifications

Public