Home
  •  

MSSQL 2016: Tipo di monitoraggio spazio disponibile nel contenitore del filegroup di dati con ottimizzazione per la memoria

Microsoft.SQLServer.2016.MonitorType.Container.FreeSpacePercent (UnitMonitorType)

Tipo di monitoraggio spazio disponibile nel contenitore del filegroup di dati con ottimizzazione per la memoria di SQL Server 2016

Element properties:

RunAsDefault
AccessibilityInternal
Support Monitor RecalculateFalse

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.DataSource.Container.FreeSpace Default
CDCritical ConditionDetection System.ExpressionFilter Default
CDSuccess ConditionDetection System.ExpressionFilter Default
CDWarning ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$Intervallo (secondi)Intervallo di tempo ricorrente in secondi in cui eseguire il flusso di lavoro.
SyncTimestring$Config/SyncTime$Ora di sincronizzazioneOra di sincronizzazione specificata usando il formato a 24 ore. Può essere omessa.
CriticalThresholddouble$Config/CriticalThreshold$Soglia criticaLo stato del monitoraggio passerà a 'Critico' se il valore scende sotto questa soglia.
WarningThresholddouble$Config/WarningThreshold$Soglia avvisoLo stato del monitoraggio passerà ad 'Avviso' se il valore scende sotto questa soglia.
TimeoutSecondsint$Config/TimeoutSeconds$Timeout (secondi)Specifica il tempo di esecuzione consentito per il flusso di lavoro prima che venga chiuso e contrassegnato come non riuscito.
ScriptDelayMsecint$Config/ScriptDelayMsec$Ritardo script (millisecondi)Questo parametro imposta il ritardo tra le query T-SQL consecutive eseguite dal flusso di lavoro. Favorisce la riduzione del footprint generato dal flusso di lavoro in presenza di un numero elevato di oggetti di destinazione. Prima di cambiare questo parametro, consultare il Supporto tecnico Microsoft.

Source Code:

<UnitMonitorType ID="Microsoft.SQLServer.2016.MonitorType.Container.FreeSpacePercent" Accessibility="Internal">

  <MonitorTypeStates>

    <MonitorTypeState ID="ContainerFreeSpaceCritical"/>

    <MonitorTypeState ID="ContainerFreeSpaceWarning"/>

    <MonitorTypeState ID="ContainerFreeSpaceSuccess"/>

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

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

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

    <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="ScriptDelayMsec" type="xsd:int"/>

  </Configuration>

  <OverrideableParameters>

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

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

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

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

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

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

  </OverrideableParameters>

  <MonitorImplementation>

    <MemberModules>

      <DataSource TypeID="Microsoft.SQLServer.2016.DataSource.Container.FreeSpace" ID="DS">

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

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

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

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

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

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

        <DBFileId>$Config/DBFileId$</DBFileId>

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

        <ScriptDelayMsec>$Config/ScriptDelayMsec$</ScriptDelayMsec>

      </DataSource>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>LessEqual</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>Greater</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>LessEqual</Operator>

                <ValueExpression>

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

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </ConditionDetection>

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

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Greater</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </ConditionDetection>

    </MemberModules>

    <RegularDetections>

      <RegularDetection MonitorTypeStateID="ContainerFreeSpaceCritical">

        <Node ID="CDCritical">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="ContainerFreeSpaceWarning">

        <Node ID="CDWarning">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

      <RegularDetection MonitorTypeStateID="ContainerFreeSpaceSuccess">

        <Node ID="CDSuccess">

          <Node ID="DS"/>

        </Node>

      </RegularDetection>

    </RegularDetections>

  </MonitorImplementation>

</UnitMonitorType>