Home
  •  

Sql Broker Availability Monitor

Microsoft.ServiceManager.SqlBrokerAvailabilityMonitor (UnitMonitor)

A monitor that looks at Sql Broker status for Operations Manager functionality.

Knowledge Base article:

Summary

An alert from this monitor and a critical state indicate that SQL Broker is misconfigured for the Service Manager Database. See the Resolutions section on how to remediate this condition.

Causes

Resolutions

Follow the following steps to remediate this problem:

Element properties:

TargetMicrosoft.SystemCenter.ServiceManager.ManagementServer
Parent MonitorMicrosoft.ServiceManager.SDKService.AvailabilityHealthRollup
CategoryStateCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.ServiceManager.SqlBrokerAvailabilityMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
SQL Server Broker disabled
SQL Server Broker for the Service Manager database is disabled
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitor" Accessibility="Public" Enabled="true" Target="SM!Microsoft.SystemCenter.ServiceManager.ManagementServer" ParentMonitorID="Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup" Remotable="true" Priority="Normal" TypeID="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitorType" ConfirmDelivery="false">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitor.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="SqlBrokerIsEnabled" MonitorTypeStateID="SqlBrokerEnabled" HealthState="Success"/>

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

  </OperationalStates>

  <Configuration/>

</UnitMonitor>