Home
  •  

Fournisseur de la taille des bases de données SQL 2016

Microsoft.SQLServer.2016.DBSizeRawPerfProvider (DataSourceModuleType)

Element properties:

TypeDataSourceModuleType
IsolationAny
AccessibilityInternal
RunAsMicrosoft.SQLServer.MonitoringAccount
OutputTypeSystem.Performance.Data

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.DBSizeRawProvider Default
HasValue ConditionDetection System.ExpressionFilter Default
InstanceFilter ConditionDetection System.ExpressionFilter Default
PerfMapper ConditionDetection System.Performance.DataGenericMapper Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$Intervalle (en secondes)L'intervalle de temps récurrent en secondes pendant lequel le workflow est exécuté.
SyncTimestring$Config/SyncTime$Heure de synchronisationL'heure de synchronisation spécifiée dans un format de 24 heures. Peut être omise.
TimeoutSecondsint$Config/TimeoutSeconds$Délai d'expiration (en secondes)Spécifie la durée pendant laquelle le workflow est autorisé à être exécuté avant d'être fermé et marqué comme un échec.
AzureMaxFileSizeMBint$Config/AzureMaxFileSizeMB$Taille de fichier Azure maximale (en Mo)Taille maximale du fichier de données stocké dans Stockage Blob Azure. Le workflow considère cette valeur comme une capacité de stockage maximale pour chaque fichier.

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2016.DBSizeRawPerfProvider" Accessibility="Internal" RunAs="GPMP!Microsoft.SQLServer.MonitoringAccount">

  <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="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="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

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

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

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

        </DataSource>

        <ConditionDetection ID="PerfMapper" TypeID="SystemPerf!System.Performance.DataGenericMapper">

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

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

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

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

        </ConditionDetection>

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

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">Property[@Name='Database']</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="String">$Config/DatabaseName$</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </ConditionDetection>

        <!--We should filter -1 values because it is inserted in datasource for DBs if queried metric (DBDiskFreeSpacePercent or DBDiskFreeSpaceMB or DB is non-read) isn't calculated -->

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

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>GreaterEqual</Operator>

              <ValueExpression>

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

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </ConditionDetection>

      </MemberModules>

      <Composition>

        <Node ID="HasValue">

          <Node ID="PerfMapper">

            <Node ID="InstanceFilter">

              <Node ID="DS"/>

            </Node>

          </Node>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <OutputType>SystemPerf!System.Performance.Data</OutputType>

</DataSourceModuleType>