MDW Appliance v2 Average Threshold Monitor

Microsoft.SQLServerAppliance.MDW2.ThreeStateAverageConsecutiveSamples (UnitMonitorType)

Microsoft Data Warehouse Appliance v2 Average Threshold Monitor.

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<UnitMonitorType ID="Microsoft.SQLServerAppliance.MDW2.ThreeStateAverageConsecutiveSamples" Accessibility="Internal">

  <MonitorTypeStates>

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

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

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

  </MonitorTypeStates>

  <Configuration>

    <xsd:element name="ComputerName" type="xsd:string" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="CounterName" type="xsd:string"/>

    <xsd:element name="ObjectName" type="xsd:string"/>

    <xsd:element name="InstanceName" type="xsd:string" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="AllInstances" type="xsd:boolean" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="Frequency" type="xsd:unsignedInt"/>

    <xsd:element name="ScaleBy" type="xsd:double" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="Threshold" type="xsd:double" minOccurs="1" maxOccurs="1"/>

    <xsd:element name="WarningNumSamples" type="xsd:unsignedInt" minOccurs="1" maxOccurs="1"/>

    <xsd:element name="ErrorNumSamples" type="xsd:unsignedInt" minOccurs="1" maxOccurs="1"/>

  </Configuration>

  <OverrideableParameters>

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

    <OverrideableParameter ID="Threshold" Selector="$Config/Threshold$" ParameterType="double"/>

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="PerfDS" TypeID="SystemPerf!System.Performance.DataProvider">

        <ComputerName>$Config/ComputerName$</ComputerName>

        <CounterName>$Config/CounterName$</CounterName>

        <ObjectName>$Config/ObjectName$</ObjectName>

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

        <AllInstances>$Config/AllInstances$</AllInstances>

        <Frequency>$Config/Frequency$</Frequency>

        <ScaleBy>$Config/ScaleBy$</ScaleBy>

      </DataSource>

      <ConditionDetection ID="Averager" TypeID="SystemPerf!System.Performance.AveragerCondition">

        <NumSamples>5</NumSamples>

      </ConditionDetection>

      <ConditionDetection ID="ConsecutiveSamples" TypeID="SystemPerf!System.Performance.ConsecutiveSamplesCondition">

        <Threshold>$Config/Threshold$</Threshold>

        <Direction>greater</Direction>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Double">Value</XPathQuery>

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

              <Value Type="Double">$Config/ErrorNumSamples$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Double">Value</XPathQuery>

                </ValueExpression>

                <Operator>Greater</Operator>

                <ValueExpression>

                  <Value Type="Double">$Config/WarningNumSamples$</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="Double">Value</XPathQuery>

                </ValueExpression>

                <Operator>LessEqual</Operator>

                <ValueExpression>

                  <Value Type="Double">$Config/ErrorNumSamples$</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="Double">Value</XPathQuery>

            </ValueExpression>

            <Operator>LessEqual</Operator>

            <ValueExpression>

              <Value Type="Double">$Config/WarningNumSamples$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="UnderThreshold">

        <Node ID="SuccessFilter">

          <Node ID="ConsecutiveSamples">

            <Node ID="Averager">

              <Node ID="PerfDS"/>

            </Node>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="OverThresholdWarning">

        <Node ID="WarningFilter">

          <Node ID="ConsecutiveSamples">

            <Node ID="Averager">

              <Node ID="PerfDS"/>

            </Node>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="OverThresholdError">

        <Node ID="ErrorFilter">

          <Node ID="ConsecutiveSamples">

            <Node ID="Averager">

              <Node ID="PerfDS"/>

            </Node>

          </Node>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>