Home
  •  

Service Pack Compliance

Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevel (UnitMonitor)

Monitors the service pack level of the database engine against the compliant setting

Knowledge Base article:

概要

This monitor checks the service pack version for this instance of SQL.A warning or error alert will be raised if it does not match the required setting.

既定では、モニターは、サービス パックが 0 でないときにアラートを生成するよう設定されています。This can be changed using overrides as required.

原因

異常な状態になるのは、Service Pack のレベルが必要なレベルにない (既定値は 0) ためです。

解決方法

This issue may be resolved by changing applying the latest service pack to SQL Server

Alternatively if the current setting is valid within your environment:

Element properties:

TargetMicrosoft.SQLServer.2012.DBEngine
Parent MonitorSystem.Health.ConfigurationState
CategoryConfigurationHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2012.ServicePackVersion
RemotableTrue
AccessibilityPublic
Alert Message
Service Pack Compliance
The service pack level of SQL instance {1} on computer {0} is not up to date
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevel" Accessibility="Public" Enabled="true" Target="SQL2012Core!Microsoft.SQLServer.2012.DBEngine" ParentMonitorID="SystemHealth!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2012.ServicePackVersion" ConfirmDelivery="false">

  <Category>ConfigurationHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2012.DBEngine.Configuration.ServicePackLevel.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

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

      <AlertParameter2>$Target/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="SPCompliant" MonitorTypeStateID="ValueGood" HealthState="Success"/>

    <OperationalState ID="SPNotCompliant" MonitorTypeStateID="ValueBad" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

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

    <SQLServiceName>$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ServiceName$</SQLServiceName>

    <IntervalSeconds>43200</IntervalSeconds>

    <GoodValue>0</GoodValue>

  </Configuration>

</UnitMonitor>