會查看 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>