Alteração da Porcentagem do Banco de Dados do SQL 2005

Microsoft.SQLServer.2005.DBPercentageChange (UnitMonitorType)

Este tipo de monitor verifica se houver alteração no espaço livre do banco de dados entre os intervalos de sondagem subsequentes.

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$	Intervalo (s)
SyncTime	string	$Config/SyncTime$	Hora da Sincronização
NumSamples	int	$Config/NumSamples$	Número de Amostras
Threshold1	double	$Config/Threshold1$	Limite Inferior
Threshold2	double	$Config/Threshold2$	Limite Superior
TimeoutSeconds	int	$Config/TimeoutSeconds$	Tempo Limite (s)

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>