Home
  •  

Windows service state

Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.WindowsServiceState (UnitMonitor)

The monitor alerts if SSRS windows service is not in running state longer than threshold.

Knowledge Base article:

Summary

This monitor checks the state of the SQL Reporting Services Windows Service.

Causes

"Not Running" state of this monitor indicates that SQL Reporting Services service is configured to start automatically but in "Stopped" state during the specific time period. This time period is defined in monitor properties and could be overridden. By default, this value is 900 seconds (15 minutes). If SQL Reporting Services turns back to "Running" state faster than that time it means that it was just reset.

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

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

Resolutions

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

View SQL Reporting Services Alerts

Overrideable Parameters

Name

Description

Default Value

Alert only if service startup type is automatic

This may only be set to 'true' or 'false'. The workflow will not consider the current startup type setting of the service if this parameter is set to 'false'. Default is 'true'.

1

Enabled

 

1

Generates Alerts

 

Yes

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow.

60

Number of samples

Indicates how many times a measured value should breach a threshold before the state is changed.

15

Synchronization Time

 

 

Element properties:

TargetMicrosoft.SQLServer.2014.ReportingServices.Instance
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2014.ReportingServices.MonitorType.Instance.WindowsServiceState
RemotableTrue
AccessibilityPublic
Alert Message
SSRS 2014: Windows Service stopped
The Windows service for the Reporting Services instance {1} has stopped on computer {0}
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.WindowsServiceState" Accessibility="Public" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2014.ReportingServices.Instance" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2014.ReportingServices.MonitorType.Instance.WindowsServiceState" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2014.ReportingServices.UnitMonitor.WindowsServiceState.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</AlertParameter1>

      <AlertParameter2>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2014.ReportingServices.Instance"]/InstanceName$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <ServiceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2014.ReportingServices.Instance"]/ServiceName$</ServiceName>

    <CheckStartupType>true</CheckStartupType>

    <SampleCount>15</SampleCount>

    <IntervalSeconds>60</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>