This monitor checks the health state of the "SQL Server Integration Services" Windows service.
This monitor checks the health state of the "SQL Server Integration Services" Windows service.
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 |
Target | Microsoft.SQLServer.IS.Windows.LocalInstance | ||
Parent Monitor | System.Health.AvailabilityState | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.SQLServer.IS.Windows.MonitorType.InstanceStatus | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<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>