DPA registration and licensing options for clustered environments
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.
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.
To monitor an Oracle multitenant container database (CDB), register each PDB contained in the CDB. You cannot register the CDB directly.
When you register two or more Oracle PDBs in the same CDB, DPA automatically creates a group for the CDB. For more information, see About monitoring Oracle multitenent databases (CDBs).
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.
For more information about licensing, see the following topics: