Home
  •  

MSSQL 2017 on Windows: SQL Server Windows Service

Microsoft.SQLServer.2017.Windows.Monitor.Database.ServiceStatus (UnitMonitor)

This monitor checks the status of the Local SQL Server 2017 Database Engine service.

Knowledge Base article:

Summary

This monitor translates state of "SQL Server Windows Service" monitor of DB Engine to Database. More details are available in "SQL Server Windows Service" monitor Knowledgebase article.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Interval (seconds)

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

60

Synchronization Time

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

 

Element properties:

TargetMicrosoft.SQLServer.2017.Windows.LocalDatabase
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2017.Windows.MonitorType.LocalDatabase.DBServiceStatus
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2017.Windows.Monitor.Database.ServiceStatus" Accessibility="Public" Enabled="true" Target="SQL2017WD!Microsoft.SQLServer.2017.Windows.LocalDatabase" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2017.Windows.MonitorType.LocalDatabase.DBServiceStatus" ConfirmDelivery="false">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <IntervalSeconds>60</IntervalSeconds>

    <SyncTime/>

    <PrincipalName>$Target/Host/Property[Type="SQL2017WD!Microsoft.SQLServer.2017.Windows.DBEngine"]/PrincipalName$</PrincipalName>

    <ServiceName>$Target/Host/Property[Type="SQL2017L!Microsoft.SQLServer.2017.Library.DBEngine"]/ServiceName$</ServiceName>

  </Configuration>

</UnitMonitor>