MSSQL em Linux: status de serviço do SQL

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

MSSQL em Linux: status de serviço do SQL.

Element properties:

Show References:
- Unit Monitors (2)

RunAs	Default
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$	Alertar somente se o tipo de inicialização do serviço for automático	Este valor só pode ser definido como 'true' ou 'false'. Se for definido como 'false’, os alertas serão disparados independentemente do tipo de inicialização definido. O valor padrão é ‘true’.
SqlTimeoutSeconds	int	$Config/SqlTimeoutSeconds$	Tempo limite da conexão de banco de dados (segundos)	O fluxo de trabalho falhará e registrará um evento, se ele não conseguir acessar o banco de dados durante o período especificado.
TimeoutSeconds	int	$Config/TimeoutSeconds$	Tempo Limite (em segundos)	Especifica o tempo que o fluxo de trabalho pode para ser executado antes de ser fechado e marcado como falha.
IntervalSeconds	int	$Config/IntervalSeconds$	Intervalo (segundos)	O intervalo de tempo recorrente em segundos no qual executar o fluxo de trabalho.
SyncTime	string	$Config/SyncTime$	Tempo de Sincronização	O tempo de sincronização especificado usando um formato de 24 horas. Pode ser omitido.
UnavailableTime	int	$Config/UnavailableTime$

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.Linux.MonitorType.SqlServiceStatus" Accessibility="Internal">

  <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="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="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>

        <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>