Home
  •  

Integration Service Health Status

Microsoft.SQLServer.IS.Windows.InstanceStatus (UnitMonitor)

This monitor checks the health state of the "SQL Server Integration Services" Windows service.

Knowledge Base article:

Summary

This monitor checks the health state of the "SQL Server Integration Services" Windows service.

Overridable Parameters

Name

Description

Default Value

Alert Priority

Defines Alert Priority.

Normal

Alert Severity

Defines Alert Severity.

Error

Alert only if service startup type is automatic

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'.

Yes

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.

300

Synchronization Time

The synchronization time specified by using a 24-hour format. May be omitted.

 

Timeout (seconds)

Specifies the time the workflow is allowed to run before being closed and marked as failed.

200

Unavailable Time (seconds)

The minimum duration of service unavailability before considering it unhealthy.

900

Element properties:

TargetMicrosoft.SQLServer.IS.Windows.LocalInstance
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.IS.Windows.MonitorType.InstanceStatus
RemotableTrue
AccessibilityPublic
Alert Message
MSSQL on Windows Integration Services: Integration Service is in unhealthy state
Integration Service "{0}" has stopped on computer "{1}".
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.IS.Windows.InstanceStatus" Enabled="true" TypeID="Microsoft.SQLServer.IS.Windows.MonitorType.InstanceStatus" ParentMonitorID="Health!System.Health.AvailabilityState" Target="Microsoft.SQLServer.IS.Windows.LocalInstance" Remotable="true" Priority="Normal" ConfirmDelivery="false" Accessibility="Public">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.IS.Windows.InstanceStatus.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/ServiceName$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/MachineName$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Healthy" MonitorTypeStateID="Running" HealthState="Success"/>

    <OperationalState ID="Critical" MonitorTypeStateID="NotRunning" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <PrincipalName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/PrincipalName$</PrincipalName>

    <ServiceName>$Target/Property[Type="Microsoft.SQLServer.IS.Windows.LocalInstance"]/ServiceName$</ServiceName>

    <CheckStartupType>true</CheckStartupType>

    <UnavailableTime>900</UnavailableTime>

    <TimeoutSeconds>200</TimeoutSeconds>

    <IntervalSeconds>300</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>