Monitors the service pack level of the database engine against the compliant setting
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.
Out of the box, the monitor is configured to alert when the service pack level is not 4 for Windows Server 2008 (for Windows Server 2008 R2 – not 3). This can be changed using overrides as required.
Unhealthy state is caused by the service pack level not being at the required level (4 is the default for Windows Server 2008; for Windows Server 2008 R2, the default value is 3).
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:
Override the monitor to change the required value for this specific instance of SQL or all instances
Disable the monitor for this specific instance of SQL or all instances
Name | Description | Default Value |
Alert Priority | Defines Alert Priority. | Normal |
Alert Severity | Defines Alert Severity. | MatchMonitorHealth |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | Yes |
Interval (seconds) | The recurring interval of time in seconds in which to run the workflow. | 43200 |
Minimal Service Pack level for SQL Server 2008 | The minimal Service Pack level as per company policy. By default, it equals to 0 (integer). | 1 |
Minimal Service Pack level for SQL Server 2008 R2 | The minimal Service Pack level as per company policy. By default, it equals to 0 (integer). | 0 |
Target | Microsoft.SQLServer.2008.DBEngine | ||
Parent Monitor | System.Health.ConfigurationState | ||
Category | ConfigurationHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SQLServer.2008.ServicePackVersion | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SQLServer.2008.DBEngine.Configuration.ServicePackLevel" Accessibility="Public" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.DBEngine" ParentMonitorID="SystemHealth!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2008.ServicePackVersion" ConfirmDelivery="false">
<Category>ConfigurationHealth</Category>
<AlertSettings AlertMessage="Microsoft.SQLServer.2008.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>4</GoodValue>
<GoodValueR2>3</GoodValueR2>
</Configuration>
</UnitMonitor>