Home
  •  

Windows의 MSSQL: 서버 Windows 서비스

Microsoft.SQLServer.Windows.MonitorType.LocalDBEngine.ServiceStatus (UnitMonitorType)

Windows의 SQL Server Windows 서비스의 검색 상태 유형을 모니터링합니다.

Element properties:

RunAsMicrosoft.SQLServer.Core.RunAs.Monitoring
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.Windows.DataSource.ServiceStatus Default
ServiceNotRunning ConditionDetection System.ExpressionFilter Default
ServiceRunning ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$간격(초)워크플로를 실행하는 반복 시간 간격(초)입니다.
SyncTimestring$Config/SyncTime$동기화 시간24시간 형식으로 지정된 동기화 시간입니다. 생략될 수 있습니다.
CheckStartupTypebool$Config/CheckStartupType$서비스 시작 유형이 자동인 경우에만 경고를 발생시킵니다.이 값은 'true' 또는 'false'로만 설정될 수도 있습니다. 이 매개 변수가 'false'로 설정된 경우 워크플로가 서비스의 현재 시작 유형 설정을 고려하지 않습니다. 기본값은 'true'입니다.
UnavailableTimeint$Config/UnavailableTime$사용할 수 없는 시간(초)서비스가 비정상 상태로 간주되려면 경과해야 하는, 서비스를 사용할 수 없는 최소 기간입니다.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.Windows.MonitorType.LocalDBEngine.ServiceStatus" Accessibility="Internal" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Monitoring">

  <MonitorTypeStates>

    <MonitorTypeState ID="Running" NoDetection="false"/>

    <MonitorTypeState ID="NotRunning" NoDetection="false"/>

  </MonitorTypeStates>

  <Configuration>

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

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

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ServiceName" 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"/>

  </Configuration>

  <OverrideableParameters>

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

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.Windows.DataSource.ServiceStatus" ID="DS">

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

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

        <PrincipalName>$Config/PrincipalName$</PrincipalName>

        <ServiceName>$Config/ServiceName$</ServiceName>

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

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

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">NotRunning</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>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>