此監視器會監視 Operations Manager 功能的 SQL Broker 狀態。
此監視器發出的警示與重大狀態表示 Service Manager 資料庫的 SQL Broker 設定不當。請參閱<解決方法>一節,了解如何補救此狀況。
使用者可能已停用 Service Manager 資料庫的 SQL Broker 或是設定錯誤。
請執行下列步驟補救此問題:
停止管理伺服器上的下列服務:OMSDK、OMCFG、HealthService
開啟 SQL Studio
連線到裝載 Service Manager 資料庫的伺服器
建立新的查詢
輸入 "ALTER DATABASE Service Manager SET ENABLE_BROKER"
執行此查詢
若查詢成功,應會出現傳回值 "0"
啟動 Root Management Server 上的下列服務:OMSDK、OMCFG、HealthService
等候監視器再度執行,或強制監視器重新計算
狀態應該回復成綠色,並會自行解決警示。
Target | Microsoft.SystemCenter.ServiceManager.ManagementServer | ||
Parent Monitor | Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup | ||
Category | StateCollection | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.ServiceManager.SqlBrokerAvailabilityMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitor" Accessibility="Public" Enabled="true" Target="SM!Microsoft.SystemCenter.ServiceManager.ManagementServer" ParentMonitorID="Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup" Remotable="true" Priority="Normal" TypeID="Microsoft.ServiceManager.SqlBrokerAvailabilityMonitorType" ConfirmDelivery="false">
<Category>StateCollection</Category>
<AlertSettings AlertMessage="Microsoft.ServiceManager.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>