Home
  •  

Site Server Connectivity To SQL Database Server

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

This monitor checks the site server connectivity to SQL database server.

Knowledge Base article:

Summary

This monitor checks the database connection between the ConfigMgr site server and the Site database server. It generates an alert when the site server fails to connect to the site database server.

Causes

There are many possible root causes, including:

Resolutions

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
Site server cannot connect to database
The site server connection to SQL server {0} is not available.
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>