Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Database Performance Analyzer (DPA) > 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: 116 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
19:17, 22 Jun 2016

Tags

Classifications

Public