• Management Pack:  SQL Server 2005
  • MP Version:  6.1
  • Released:  8/5/2010
  • Publisher:  Microsoft

Service Pack Compliance Monitor

  • ID:  Microsoft.SQLServer.2005.DBEngine.Configuration.ServicePackLevel
  • Description:  Monitors the service pack level of the database engine against the compliant setting
  • Target:  SQL Server 2005 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
Service Pack Version OK Success  
Service Pack Version Not OK Warning  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (sec) 43200  
Good Value 1  

Alert Details

Monitor State Message Priority Severity Auto Resolution
Service Pack Version Not OK (Warning) Service Pack Compliance Medium Match Monitor Health Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

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 1. This can be changed using overrides as required.

Causes

An unhealthy state is caused by the service pack level not being at the required level (1 is the default)

Resolutions

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

External References
This monitor does not contain any external references.

See Also for SQL Server 2005 Management Pack


Downloads for SQL Server 2005 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED