Home
  •  

MSSQL 2014: Alteração do Percentual do Banco de Dados

Microsoft.SQLServer.2014.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:

RunAsDefault
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2014.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)O intervalo de tempo recorrente em segundos no qual executa-se o fluxo de trabalho.
SyncTimestring$Config/SyncTime$Hora da SincronizaçãoA hora da sincronização especificada usando um formato de 24 horas. Pode ser omitido.
NumSamplesint$Config/NumSamples$Número de amostrasIndica quantas vezes um valor medido deve violar um limite antes do estado ser alterado.
Threshold1double$Config/Threshold1$Limite de AvisoLimite de Aviso. Ultrapassar esse limite fará com que o monitor passe pelo menos para um estado de aviso.
Threshold2double$Config/Threshold2$Limite CríticoO monitor mudará seu estado para Crítico se o valor exceder esse limite. Estar entre esse limite e o limite de aviso (inclusivo) resultará no monitor estando em um estado de aviso.
TimeoutSecondsint$Config/TimeoutSeconds$Tempo Limite (segundos)Especifica o tempo que o fluxo de trabalho pode funcionar antes de ser fechado e marcado como com falha.
AzureMaxFileSizeMBint$Config/AzureMaxFileSizeMB$Tamanho Máximo de Arquivo Azure (MB)O tamanho máximo do arquivo de dados armazenado no Armazenamento BLOB do Azure. O fluxo de trabalho considerará esse valor como a capacidade máxima de armazenamento para cada arquivo.

Source Code:

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

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="AzureMaxFileSizeMB" 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$"/>

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.2014.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>

        <AzureMaxFileSizeMB>$Config/AzureMaxFileSizeMB$</AzureMaxFileSizeMB>

      </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>