MSSQL on Linux: SQL Service Status

Microsoft.SQLServer.Linux.MonitorType.SqlServiceStatus (UnitMonitorType)

MSSQL on Linux: SQL Service Status.

Element properties:

Show References:
- Unit Monitors (2)

RunAs	Microsoft.SQLServer.Core.RunAs.Monitoring
Accessibility	Internal
Support Monitor Recalculate	False

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.Linux.DataSource.SqlServiceStatus	Default
ServiceNotRunning	ConditionDetection	System.ExpressionFilter	Default
ServiceRunning	ConditionDetection	System.ExpressionFilter	Default
UnableToDetectServiceStatus	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
CheckStartupType	bool	$Config/CheckStartupType$	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'.
SqlExecTimeoutSeconds	int	$Config/SqlExecTimeoutSeconds$	Timeout for query execution (seconds)	The workflow will fail and register an event, if the query execution takes longer than the specified period.
SqlTimeoutSeconds	int	$Config/SqlTimeoutSeconds$	Timeout for database connection (seconds)	The workflow will fail and register an event, if it cannot access the database during the specified period.
TimeoutSeconds	int	$Config/TimeoutSeconds$	Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.
IntervalSeconds	int	$Config/IntervalSeconds$	Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.
SyncTime	string	$Config/SyncTime$	Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.
UnavailableTime	int	$Config/UnavailableTime$	Unavailable Time (seconds)	The minimum duration of service unavailability before considering it unhealthy.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.Linux.MonitorType.SqlServiceStatus" Accessibility="Internal" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Monitoring">

  <MonitorTypeStates>

    <MonitorTypeState ID="Running"/>

    <MonitorTypeState ID="NotRunning"/>

    <MonitorTypeState ID="UnableToDetectStatus"/>

  </MonitorTypeStates>

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="MachineName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="NetbiosComputerName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceVersion" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceEdition" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ServiceType" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="CheckStartupType" type="xsd:boolean"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="UnavailableTime" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlExecTimeoutSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlTimeoutSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:int"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="IntervalSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SyncTime" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="CheckStartupType" ParameterType="bool" Selector="$Config/CheckStartupType$"/>

    <OverrideableParameter ID="SqlExecTimeoutSeconds" ParameterType="int" Selector="$Config/SqlExecTimeoutSeconds$"/>

    <OverrideableParameter ID="SqlTimeoutSeconds" ParameterType="int" Selector="$Config/SqlTimeoutSeconds$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

    <OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>

    <OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>

    <OverrideableParameter ID="UnavailableTime" ParameterType="int" Selector="$Config/UnavailableTime$"/>

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.Linux.DataSource.SqlServiceStatus" ID="DS">

        <MachineName>$Config/MachineName$</MachineName>

        <NetbiosComputerName>$Config/NetbiosComputerName$</NetbiosComputerName>

        <InstanceName>$Config/InstanceName$</InstanceName>

        <ConnectionString>$Config/ConnectionString$</ConnectionString>

        <InstanceVersion>$Config/InstanceVersion$</InstanceVersion>

        <InstanceEdition>$Config/InstanceEdition$</InstanceEdition>

        <ServiceType>$Config/ServiceType$</ServiceType>

        <CheckStartupType>$Config/CheckStartupType$</CheckStartupType>

        <UnavailableTime>$Config/UnavailableTime$</UnavailableTime>

        <SqlExecTimeoutSeconds>$Config/SqlExecTimeoutSeconds$</SqlExecTimeoutSeconds>

        <SqlTimeoutSeconds>$Config/SqlTimeoutSeconds$</SqlTimeoutSeconds>

        <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

        <IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>

        <SyncTime>$Config/SyncTime$</SyncTime>

      </DataSource>

      <ConditionDetection ID="ServiceRunning" TypeID="System!System.ExpressionFilter">

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='IsError']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">false</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <Or>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="String">Property[@Name='ServiceExists']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="String">false</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="Integer">Property[@Name='Status']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="Integer">4</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <And>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="String">Property[@Name='CheckStartupType']</XPathQuery>

                        </ValueExpression>

                        <Operator>Equal</Operator>

                        <ValueExpression>

                          <Value Type="String">true</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                    <Expression>

                      <SimpleExpression>

                        <ValueExpression>

                          <XPathQuery Type="Integer">Property[@Name='StartupType']</XPathQuery>

                        </ValueExpression>

                        <Operator>NotEqual</Operator>

                        <ValueExpression>

                          <Value Type="Integer">2</Value>

                        </ValueExpression>

                      </SimpleExpression>

                    </Expression>

                  </And>

                </Expression>

              </Or>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="ServiceNotRunning" TypeID="System!System.ExpressionFilter">

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='IsError']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">false</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="String">Property[@Name='ServiceExists']</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">true</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Integer">Property[@Name='Status']</XPathQuery>

                </ValueExpression>

                <Operator>NotEqual</Operator>

                <ValueExpression>

                  <Value Type="Integer">4</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <Or>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="Integer">Property[@Name='CheckStartupType']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="String">false</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

                <Expression>

                  <SimpleExpression>

                    <ValueExpression>

                      <XPathQuery Type="Integer">Property[@Name='StartupType']</XPathQuery>

                    </ValueExpression>

                    <Operator>Equal</Operator>

                    <ValueExpression>

                      <Value Type="Integer">2</Value>

                    </ValueExpression>

                  </SimpleExpression>

                </Expression>

              </Or>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

      <ConditionDetection ID="UnableToDetectServiceStatus" TypeID="System!System.ExpressionFilter">

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">Property[@Name='IsError']</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">true</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="Running">

        <Node ID="ServiceRunning">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="NotRunning">

        <Node ID="ServiceNotRunning">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="UnableToDetectStatus">

        <Node ID="UnableToDetectServiceStatus">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>