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

SQL Server Integration Services Windows Service Monitor

  • ID:  Microsoft.SQLServer.2008.IntegrationServices.ServiceMonitor
  • Description:  This monitor checks the status of the SQL Integration Services service.
  • Target:  SQL 2008 Integration Services
  • Enabled:  Yes

Operational States

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

Overridable Parameters

Parameter Name Default Value Description Override
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'.

Alert Details

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

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

This monitor checks the status of the SQL Integration Services service and generates an alert when the service is set to start automatically and is not running.

Note that an alert is not generated when the service is disabled and a healthy state will be shown.

Causes

A service can stop for 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 Integration Services 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 Management Pack


Downloads for SQL Server 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