A monitor that looks at Sql Broker status for Operations Manager functionality.
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.
This can be caused by someone disabling SQL Broker for the Operations Manager Operational Database or a configuration error.
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"
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.
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 |
| ||
RunAs | Default |
<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>