此监视器查看 Operations Manager 功能的 SQL Broker 状态。
此监视器发出的警报和严重状态表示对于 Operations Manager 操作数据库,SQL Broker 配置错误。有关如何更正此情形的信息,请参阅“解决方法”部分。
这可能是由于某人为 Operations Manager 操作数据库禁用了 SQL Broker 或配置错误引起的。
请按照下列步骤更正此问题。
停止管理服务器上的以下服务:OMSDK、OMCFG、HealthService
打开 SQL Studio
连接到主持 Operations Manager 操作数据库的服务器
创建新查询
键入 "ALTER DATABASE OperationsManager SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;"
执行此查询
如果查询成功,你应看到返回值 "0"
启动管理服务器上的以下服务:OMSDK、OMCFG、HealthService
等到监视器再次运行,或者强制监视器重新进行计算。
状态应恢复为正常,而警报应自动解决。
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>