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

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

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}" on computer "{1}" is in unhealthy state and reports "{2}".
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>

      <AlertParameter3>$Data/Context/Property[@Name='StatusText']$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

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

    <IntervalSeconds>300</IntervalSeconds>

    <SyncTime/>

    <TimeoutSeconds>200</TimeoutSeconds>

  </Configuration>

</UnitMonitor>