Sql Broker Availability Monitor - Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor (UnitMonitor)

Microsoft.SystemCenter.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 Operations Manager Operational Database. Please see the Resolutions section on how to remediate this condition.

Causes

This can be caused by someone disabling SQL Broker for the Operations Manager Operational Database or a configuration error.

Resolutions

Follow the below steps to remediate this problem.

Stop the following services on the Management Server: OMSDK, OMCFG, HealthService
Open SQL Studio
Connect to the server that hosts the Operations Manager Operational Database
Create a new query
Type "ALTER DATABASE OperationsManager SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;"
Execute this query
If the query is successful, you should see a return value of "0"
Start the following services on the Management Server: OMSDK, OMCFG, HealthService
Wait until the monitor runs again, or force the monitor to recalculate.
The state should return to Healthy and the alert should be autoresolved.

Element properties:

Target

Microsoft.SystemCenter.RootManagementServer

Parent Monitor

System.Health.AvailabilityState

Category

StateCollection

Enabled

False

Alert Generate

True

Alert Severity

Error

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.SystemCenter.SqlBrokerAvailabilityMonitorType

Remotable

True

Accessibility

Public

Alert Message

SQL Server Broker disabled

SQL Server Broker for the Operations Manager database is disabled

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor" Accessibility="Public" Enabled="false" Target="SCLibrary!Microsoft.SystemCenter.RootManagementServer" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SystemCenter.SqlBrokerAvailabilityMonitorType" ConfirmDelivery="false"> <Category>StateCollection</Category> <AlertSettings AlertMessage="Microsoft.SystemCenter.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>