Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Create an alert on SQL Database Mirroring Status

Create an alert on SQL Database Mirroring Status

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

Views: 1,976 Votes: 0 Revisions: 3

Overview

NOTE: This article is for informational purposes only. Solarwinds Support cannot assist with custom SQL alerts.
The following steps will detail how you can create an alert based on the Database Mirroring Status when monitoring the SQL via AppInsight for SQL.

Environment

SAM 6.0 and later

Steps

  1. Open Alert Manager via Settings > Manage Alerts.
  2. Create a new alert.
  3. In the Trigger Conditions, specify the following:
    I want to alert on: Custom SWQL Alert (Advanced)

    Set up your SWQL condition:
    AppInsight for SQL: Database

    SELECT SqlDatabase.Uri, SqlDatabase.DisplayName FROM Orion.APM.SqlDatabase AS SqlDatabase
    INNER JOIN Orion.APM.SqlDatabaseMirroring as Mirroring ON SqlDatabase.DatabaseID=Mirroring.DatabaseID
    WHERE Mirroring.State != '4'

 

Last modified

Tags

Classifications

Public