Home
  •  

数据库大小原始映射的数据源 2016

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

针对收集 SQL 2016 数据库可用空间的数据源返回 System.Performance.Data

Element properties:

TypeDataSourceModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
OutputTypeSystem.Performance.Data

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.SQLServer.2016.DBSizeRawPerfProvider Default
HasValue ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$间隔(秒)运行工作流的重复间隔时间(秒)。
TimeoutSecondsint$Config/TimeoutSeconds$超时(秒)指定允许工作流在被关闭并标记为失败之前运行的时间。
AzureMaxFileSizeMBint$Config/AzureMaxFileSizeMB$Azure 文件最大大小(MB)存储在 Azure BLOB 存储中的数据文件的最大大小。工作流会将此值视为每个文件的最大存储容量。

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>