Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 468 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