資料倉儲效能資料編寫器 (自訂路由)

Microsoft.SystemCenter.DataWarehouse.PerformanceDataWriter (WriteActionModuleType)

使用此模組，以自訂路由 (自訂資料集) 將效能資料寫入資料倉儲

Element properties:

Show References:
- Rules (1)
- WriteAction Modules (1)

Type	WriteActionModuleType
Isolation	Any
Accessibility	Public
RunAs	Default
InputType	Microsoft.SystemCenter.Performance.LinkedData

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	Microsoft.SystemCenter.DataWarehouse.PerformanceDataWriterInternal	Default

Overrideable Parameters:

ID	ParameterType	Selector	Display Name	Description
MaxExecutionAttemptCount	int	$Config/MaxExecutionAttemptCount$	寫入作業執行嘗試計數上限	嘗試上限模組會在宣告無法處理資料項目之前先執行。值若為零，表示模組將持續執行 (無嘗試次數上限)
ExecutionAttemptTimeoutIntervalSeconds	int	$Config/ExecutionAttemptTimeoutIntervalSeconds$	後續的執行嘗試逾時間隔，以秒為單位	兩次後續執行嘗試之間的間隔秒數
BulkInsertBatchSize	int	$Config/BulkInsertBatchSize$	大量插入批次大小	大量插入作業的批次大小上限
MaxBatchesToProcessBeforeMaintenanceCount	int	$Config/MaxBatchesToProcessBeforeMaintenanceCount$	維護之前要處理的資料項目批次上限	資料項目批次上限模組會在執行資料集維護作業前處理

Source Code:

<WriteActionModuleType ID="Microsoft.SystemCenter.DataWarehouse.PerformanceDataWriter" Accessibility="Public" Batching="false">

  <Configuration>

    <xsd:element name="DataRoutingKey" type="xsd:string" minOccurs="1" maxOccurs="1"/>

    <xsd:element name="BulkInsertBatchSize" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="MaxBatchesToProcessBeforeMaintenanceCount" type="xsd:positiveInteger" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="MaxExecutionAttemptCount" type="xsd:int" minOccurs="0" maxOccurs="1"/>

    <xsd:element name="ExecutionAttemptTimeoutIntervalSeconds" type="xsd:int" minOccurs="0" maxOccurs="1"/>

  </Configuration>

  <OverrideableParameters>

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

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

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

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

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <WriteAction ID="WA" TypeID="Microsoft.SystemCenter.DataWarehouse.PerformanceDataWriterInternal">

          <ManagementGroupId>$Target/ManagementGroup/Id$</ManagementGroupId>

          <DataSetId>$MPElement[Name="Microsoft.SystemCenter.DataWarehouse.DataSet.Performance"]$</DataSetId>

          <DataRoutingKey>$Config/DataRoutingKey$</DataRoutingKey>

          <TableName>Perf.PerformanceStage</TableName>

          <BulkInsertBatchSize>$Config/BulkInsertBatchSize$</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>$Config/MaxBatchesToProcessBeforeMaintenanceCount$</MaxBatchesToProcessBeforeMaintenanceCount>

          <MaxExecutionAttemptCount>$Config/MaxExecutionAttemptCount$</MaxExecutionAttemptCount>

          <ExecutionAttemptTimeoutIntervalSeconds>$Config/ExecutionAttemptTimeoutIntervalSeconds$</ExecutionAttemptTimeoutIntervalSeconds>

          <SqlAuthentication>

            <Login>$RunAs[Name="Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/UserName$</Login>

            <Password>$RunAs[Name="Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount"]/Password$</Password>

          </SqlAuthentication>

        </WriteAction>

      </MemberModules>

      <Composition>

        <Node ID="WA"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <InputType>SystemCenter!Microsoft.SystemCenter.Performance.LinkedData</InputType>

</WriteActionModuleType>