Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Register and monitor an Availability Group

Register and monitor an Availability Group

Table of contents
Created by Mandeville, last modified by MindTouch on Jun 23, 2016

Views: 2,669 Votes: 0 Revisions: 10

Overview

This article describes how to register and monitor an Availability Group.

Environment

  • All versions of SQL that support Availability Groups
  • All versions of DPA

Steps

Use the the listener IP address to register and monitor an Always On or AG database.
Note: When first registering the AG or Availability Group, DPA sees the physical IP address of the host where the AG is primary.

When the AG fails over to another host, the DPA monitoring will follow the listener and continue monitoring.

Note: As you monitor at the instance level, there may be anomalies seen as to databases monitored (the same databases may not exist in the SQL instance on node A as node B). DPA currently does not limit databases it monitors within any given instance.

After the instance is registered, configure DPA to connect to the AG through the listener IP address:

  1. From the Home Page, click the Options link in the upper right hand side of the screen.
  2. On the Monitor Setup tab, click the Update Connection Info in the first column
  3. Once the connection wizard is launched, select the correct instance that represents the AG group and then click Next.
  4. Enter in the listener IP address for the AG listener, as shown in the following screenshot.
Last modified

Tags

Classifications

Public