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
  • Enabled:  Yes

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 OpsMgr 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 OpsMgr Operational Database or a configuration error.

Resolutions

Follow the below steps to remediate this problem.

  • Stop the following services on the Root Management Server: OMSDK, OMCFG, HealthService

  • Open SQL Studio

  • Connect to the server that hosts the OpsMgr 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 Root Management Server: OMSDK, OMCFG, HealthService

  • Wait until the monitor runs again, or force the monitor to recalculate.

  • The state should return to green and the alert should be autoresolved.

External References
This monitor does not contain any external references.

See Also for System Center Library Management Pack


Downloads for System Center Library 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