Changement de pourcentage de la base de données SQL 2005

Microsoft.SQLServer.2005.DBPercentageChange (UnitMonitorType)

Ce type d'analyse recherche un changement de l'espace libre de la base de données entre les fréquences d'interrogation successives.

Element properties:

Show References:
- Unit Monitors (1)

RunAs	Default
Accessibility	Internal
Support Monitor Recalculate	False

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2005.DBSizeRawPerfProvider	Default
CDDeltaThreshold	ConditionDetection	System.Performance.DeltaValueCondition	Default
CDOverThreshold1UnderThreshold2	ConditionDetection	System.ExpressionFilter	Default
CDOverThreshold2	ConditionDetection	System.ExpressionFilter	Default
CDUnderThreshold1	ConditionDetection	System.ExpressionFilter	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name
IntervalSeconds	int	$Config/IntervalSeconds$	Intervalle (secondes)
SyncTime	string	$Config/SyncTime$	Heure de synchronisation
NumSamples	int	$Config/NumSamples$	Nombre d'échantillons
Threshold1	double	$Config/Threshold1$	Seuil inférieur
Threshold2	double	$Config/Threshold2$	Seuil supérieur
TimeoutSeconds	int	$Config/TimeoutSeconds$	Délai d'attente (secondes)

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2005.DBPercentageChange" Accessibility="Internal">

  <MonitorTypeStates>

    <MonitorTypeState ID="UnderThreshold1"/>

    <MonitorTypeState ID="OverThreshold1UnderThreshold2"/>

    <MonitorTypeState ID="OverThreshold2"/>

  </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="ConnectionString" type="xsd:string"/>

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

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

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

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

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

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

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

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

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

  </Configuration>

  <OverrideableParameters>

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

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

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

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.2005.DBSizeRawPerfProvider" ID="DS">

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

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

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

        <ServerName>$Config/ServerName$</ServerName>

        <SqlInstanceName>$Config/SqlInstanceName$</SqlInstanceName>

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

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

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

        <DatabaseName>$Config/DatabaseName$</DatabaseName>

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

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

      </DataSource>

      <ConditionDetection TypeID="SystemPerf!System.Performance.DeltaValueCondition" ID="CDDeltaThreshold">

        <NumSamples>$Config/NumSamples$</NumSamples>

        <Absolute>true</Absolute>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

              <Value Type="Double">-$Config/Threshold1$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>LessEqual</Operator>

                <ValueExpression>

                  <Value Type="Double">-$Config/Threshold1$</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>GreaterEqual</Operator>

                <ValueExpression>

                  <Value Type="Double">-$Config/Threshold2$</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Less</Operator>

            <ValueExpression>

              <Value Type="Double">-$Config/Threshold2$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="UnderThreshold1">

        <Node ID="CDUnderThreshold1">

          <Node ID="CDDeltaThreshold">

            <Node ID="DS"/>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="OverThreshold1UnderThreshold2">

        <Node ID="CDOverThreshold1UnderThreshold2">

          <Node ID="CDDeltaThreshold">

            <Node ID="DS"/>

          </Node>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="OverThreshold2">

        <Node ID="CDOverThreshold2">

          <Node ID="CDDeltaThreshold">

            <Node ID="DS"/>

          </Node>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>