Home
  •  

MSSQL 2008: cambio en la base de datos (porcentaje)

Microsoft.SQLServer.2008.DBPercentageChange (UnitMonitorType)

Este tipo de monitor comprueba si hay cambios en el espacio disponible de la base de datos entre intervalos de sondeo consecutivos.

Element properties:

RunAsDefault
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2008.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:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$Intervalo (segundos)Intervalo de tiempo periódico en segundos en el que se ejecuta el flujo de trabajo.
SyncTimestring$Config/SyncTime$Hora de sincronizaciónHora de sincronización especificada en un formato de 24 horas. Se puede omitir.
NumSamplesint$Config/NumSamples$Número de ejemplosIndica cuántas veces debe superar un umbral un valor medido antes de que cambie el estado.
Threshold1double$Config/Threshold1$Umbral inferiorEl umbral inferior de este monitor.
Threshold2double$Config/Threshold2$Umbral superiorUmbral superior de este monitor.
TimeoutSecondsint$Config/TimeoutSeconds$Tiempo de espera (segundos)Especifica el tiempo durante el que se permite el flujo de trabajo para ejecutarse antes de cerrarse y de marcarse como incorrecto.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2008.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.2008.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>