MySQL tárolt eljárás – küszöbérték-figyelő

Microsoft.MySQLStoredProcedure.ThresholdUnitMonitor.MonitorType (UnitMonitorType)

Element properties:

RunAs	Default
Accessibility	Public
Support Monitor Recalculate	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.MySQLStoredProcedure.WSMan.PerfCounterProvider	Default
CDOverThreshold	ConditionDetection	System.ExpressionFilter	Default
CDUnderThreshold	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
Interval	int	$Config/Interval$	MySQL tárolt eljárás – küszöbérték-figyelési időköz	MySQL tárolt eljárás – küszöbérték-figyelési időköz
MySQLDatabaseName	string	$Config/MySQLDatabaseName$	MySQL tárolt eljárás – a MySQL-adatbázis neve	MySQL tárolt eljárás – a MySQL-adatbázis neve
MySQLPort	string	$Config/MySQLPort$	A MySQL tárolt eljárás MySQL-portja	A MySQL tárolt eljárás MySQL-portja
MySQLStoredProcedureName	string	$Config/MySQLStoredProcedureName$	A MySQL tárolt eljárás neve	A MySQL tárolt eljárás neve
MySQLStoredProcedureParameters	string	$Config/MySQLStoredProcedureParameters$	A MySQL tárolt eljárás paraméterei	A MySQL tárolt eljárás paraméterei

Source Code:

<UnitMonitorType ID="Microsoft.MySQLStoredProcedure.ThresholdUnitMonitor.MonitorType" Accessibility="Public">

  <MonitorTypeStates>

    <MonitorTypeState ID="UnderThreshold"/>

    <MonitorTypeState ID="OverThreshold"/>

  </MonitorTypeStates>

  <Configuration>

    <IncludeSchemaTypes>

      <SchemaType>System!System.ExpressionEvaluatorSchema</SchemaType>

    </IncludeSchemaTypes>

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

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

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

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

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

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

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

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

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

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

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

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

  </Configuration>

  <OverrideableParameters>

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

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

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource ID="DS" TypeID="Microsoft.MySQLStoredProcedure.WSMan.PerfCounterProvider">

        <TargetSystem>$Config/TargetSystem$</TargetSystem>

        <Interval>$Config/Interval$</Interval>

        <MySQLDatabaseName>$Config/MySQLDatabaseName$</MySQLDatabaseName>

        <MySQLPort>$Config/MySQLPort$</MySQLPort>

        <MySQLStoredProcedureName>$Config/MySQLStoredProcedureName$</MySQLStoredProcedureName>

        <MySQLStoredProcedureParameters>$Config/MySQLStoredProcedureParameters$</MySQLStoredProcedureParameters>

        <RowFilterExpression>$Config/RowFilterExpression$</RowFilterExpression>

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

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

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

        <Value>$Config/MetricXPath$</Value>

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>LessEqual</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="UnderThreshold">

        <Node ID="CDUnderThreshold">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="OverThreshold">

        <Node ID="CDOverThreshold">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

    <OnDemandDetections>

      <OnDemandDetection MonitorTypeStateID="UnderThreshold">

        <Node ID="CDUnderThreshold">

          <Node ID="DS"/>

        </Node>

      </OnDemandDetection>

      <OnDemandDetection MonitorTypeStateID="OverThreshold">

        <Node ID="CDOverThreshold">

          <Node ID="DS"/>

        </Node>

      </OnDemandDetection>

    </OnDemandDetections>

  </MonitorImplementation>

</UnitMonitorType>