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 > Server & Application Monitor (SAM) > Monitor an active/passive SQL Server Cluster

Monitor an active/passive SQL Server Cluster

Table of contents
Created by Mandeville, last modified by Mandeville on Sep 19, 2016

Views: 1,343 Votes: 6 Revisions: 5

Overview

This article provides steps on how to monitor an active/passive SQL Server cluster in SAM. This helps avoid false down conditions for monitors due to certain drives and services that do not go up on the passive node.

Note: This is not applicable for Always On Availability Groups (AGs).

Environment

All versions of SAM

Steps

  1. Add both physical nodes by their physical IP or hostname that resolves to the physical IP address.
  2. Select your polling method. NOTE: this will not work if you are monitoring using agents.
  3. Register the cluster hostname or VIP that failover to the secondary node in the case of a failover of cluster resources.
  4. Assign any SQL Server monitoring using the cluster hostname or VIP.

 

Last modified

Tags

Classifications

Public