Source de données mappée de la taille brute de la base de données 2016

Microsoft.SQLServer.2016.Database.DBSizeRaw.DataSourceMapped (DataSourceModuleType)

La source de données pour la collecte de l'espace libre des bases de données SQL 2016 retourne System.Performance.Data

Element properties:

Member Modules:

Overrideable Parameters:

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2016.Database.DBSizeRaw.DataSourceMapped" Accessibility="Internal">

  <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="TimeoutSeconds" type="xsd:integer"/>

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

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

  </Configuration>

  <OverrideableParameters>

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

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

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

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

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

          <SyncTime/>

          <ConnectionString>$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$</ConnectionString>

          <ServerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ServerName>

          <SqlInstanceName>$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.ServerRole"]/InstanceName$</SqlInstanceName>

          <ObjectName>SQL Database</ObjectName>

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

          <InstanceName/>

          <DatabaseName>$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$</DatabaseName>

          <Value>$Data/Property[@Name='$Config/CounterKey$']$</Value>

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

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

        </DataSource>

        <!--We should filter -1 values because it is inserted in datasource for DBs if queried metric (DBDiskFreeSpacePercent or DBDiskFreeSpaceMB) 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="DS"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

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

</DataSourceModuleType>