Home
  •  

SQL 資料庫伺服器的站台伺服器連線

Microsoft.SystemCenter2012.ConfigurationManager.Database.ConnectivityMonitor (UnitMonitor)

此監視會檢查 SQL 資料庫伺服器的站台伺服器連線。

Knowledge Base article:

摘要

此監視會檢查 ConfigMgr 站台伺服器與站台資料庫伺服器之間的資料庫連線。 當站台伺服器無法連線到站台資料庫伺服器時，便會產生警示。

原因

可能的根本原因很多，包括：

解決方式

Element properties:

TargetMicrosoft.SystemCenter2012.ConfigurationManager.SiteServerRoleBaseClass
Parent MonitorMicrosoft.SystemCenter2012.ConfigurationManager.RoleAggregateMonitor
CategoryCustom
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SystemCenter2012.ConfigurationManager.RoleAvailabilityMonitor
RemotableTrue
AccessibilityPublic
Alert Message
站台伺服器無法連線到資料庫
SQL Server {0} 的站台伺服器連線無法使用。
RunAsDefault
CommentSIV:GEN0215

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter2012.ConfigurationManager.Database.ConnectivityMonitor" Comment="SIV:GEN0215" Accessibility="Public" Enabled="onEssentialMonitoring" Target="SCCM!Microsoft.SystemCenter2012.ConfigurationManager.SiteServerRoleBaseClass" ParentMonitorID="Microsoft.SystemCenter2012.ConfigurationManager.RoleAggregateMonitor" Remotable="true" Priority="Normal" TypeID="Microsoft.SystemCenter2012.ConfigurationManager.RoleAvailabilityMonitor" ConfirmDelivery="true">

  <Category>Custom</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter2012.ConfigurationManager.Database.ConnectivityMonitor_AlertMessageResourceID">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="UIGeneratedOpStateId56dbc36a28e84523ad1e7abfe018e0ef" MonitorTypeStateID="Good" HealthState="Success"/>

    <OperationalState ID="UIGeneratedOpStateId23cc4916522a4a9e8f14b55c969bb363" MonitorTypeStateID="Warning" HealthState="Warning"/>

    <OperationalState ID="UIGeneratedOpStateId182294f9f9324cdcbe681eb19d7f32d1" MonitorTypeStateID="Error" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>

    <RoleName>SMS SQL Server</RoleName>

    <IntervalSeconds>360</IntervalSeconds>

  </Configuration>

</UnitMonitor>