Sql Broker Availability Monitor Monitor

  • ID:  Microsoft.SystemCenter.SqlBrokerAvailabilityMonitor
  • Description:  A monitor that looks at Sql Broker status for Operations Manager functionality.
  • Target:  Root Management Server Emulator
  • Enabled:  No

Operational States

Name State Description
Sql Broker is enabled. Success Sql Broker is properly enabled for Operations Manager functionality.
Sql Broker is disabled. Error Sql Broker is disabled and some Operations Manager functionality will not work.

Alert Details

Monitor State Message Priority Severity Auto Resolution
Sql Broker is disabled. (Error) SQL Server Broker disabled Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

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.

External References
This monitor does not contain any external references.

See Also for System Center 2016 Operations Manager inbox MP hotfix for WMI health monitor issue Management Pack


Downloads for System Center 2016 Operations Manager inbox MP hotfix for WMI health monitor issue Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED