Home
  •  

Database Relation Monitor

Microsoft.ServiceBus.v1.1.DatabaseRelationMonitor (UnitMonitor)

Knowledge Base article:

Summary

Database relation monitor.

Causes

There is no installed System Center Monitoring pack for SQL Server

Resolutions

This monitor is optional, you can disable it. If you would like to enable it, you should download and install System Center Monitoring pack for SQL Server before. Download SQL MP

Element properties:

TargetMicrosoft.ServiceBus.v1.1.SBWFDatabase
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.ServiceBus.v1.1.DatabaseRelationMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
Database is not healthy
DB {0} has no health - check that SQL Server discovery and SQL Server monitoring MPs are imported
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ServiceBus.v1.1.DatabaseRelationMonitor" TypeID="Microsoft.ServiceBus.v1.1.DatabaseRelationMonitorType" Accessibility="Public" Enabled="true" Target="Microsoft.ServiceBus.v1.1.SBWFDatabase" Remotable="true" Priority="Normal" ParentMonitorID="Health!System.Health.PerformanceState" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.ServiceBus.v1.1.DatabaseRelationMonitor.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="MSL!Microsoft.SQLServer.Database"]/DatabaseName$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Normal" MonitorTypeStateID="Normal" HealthState="Success"/>

    <OperationalState ID="Error" MonitorTypeStateID="Error" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>60</IntervalSeconds>

  </Configuration>

</UnitMonitor>