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

SQL Server Windows Service Monitor

  • ID:  Microsoft.SQLServer.2005.DBEngine.ServiceMonitor
  • Description:  This monitor checks the status of the SQL Database Engine service.
  • Target:  SQL Server 2005 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
Windows Service Running Success  
Windows Service Not Running Error  

Overridable Parameters

Parameter Name Default Value Description Override
Interval (sec) 60  
Alert only if service startup type is automatic true This may only be set to 'true' or 'false'. If set to 'false', then alerts will be triggered no matter what the startup type is set to. Default is 'true'.
Unavailable Time (sec) 900  

Alert Details

Monitor State Message Priority Severity Auto Resolution
Windows Service Not Running (Error) SQL Server Service Stopped Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

This monitor checks the state of the SQL Database Engine Windows Service.

Causes

"Not Running" state of this monitor indicates that SQL DB Engine service is configured to start automatically but in "Stopped" state during the specific time period. This time period is defined in "Unavailable Time" monitor property and could be overriden. By default this value is 900 secs (15 mins). If SQL DB Engine turn back to "Running" state faster than that time it means that it was just reseted.

If this monitor is too noisy in specific environment please increate "Unavailable Time". Otherwise if it's too latent, please reduce "Unavailable Time" value.

In general windows service could be stopped by many reasons, including:

  • The service was stopped by an administrator

  • The service was prevented from starting because the user account could not be authenticated.

  • The service encountered an exception that stopped the service.

  • The service was improperly configured, which prevented it from starting.

Resolutions

You can attempt to restart the service using the following link:

Start SQL DB Engine service

You can view other alerts for this instance of SQL Server™ that may be related to this issue using the following link:

View SQL Server Alerts

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