Process Monitoring: Process Performance Collection Write Action

Microsoft.Windows.Server.10.0.Process.PerfMetricsDW.WriteAction (WriteActionModuleType)

This write action writes the Process Performance into SCOM data warehouse.

Element properties:

Member Modules:

Source Code:

<WriteActionModuleType ID="Microsoft.Windows.Server.10.0.Process.PerfMetricsDW.WriteAction" Accessibility="Internal">

  <Configuration/>

  <OverrideableParameters/>

  <ModuleImplementation Isolation="Any">

    <Composite>

      <MemberModules>

        <WriteAction ID="WA" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.BulkInsertBulkDataWriter">

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

          <DataSetId>$MPElement[Name='Microsoft.Windows.Server.10.0.MetricsCollection.Dataset']$</DataSetId>

          <DataRoutingKey/>

          <BulkInsertBatchSize>5000</BulkInsertBatchSize>

          <MaxBatchesToProcessBeforeMaintenanceCount>100</MaxBatchesToProcessBeforeMaintenanceCount>

          <TableName>ProcessMonitoring.ProcesStaging</TableName>

          <MaxExecutionAttemptCount>0</MaxExecutionAttemptCount>

          <ExecutionAttemptTimeoutIntervalSeconds>0</ExecutionAttemptTimeoutIntervalSeconds>

          <TableColumns>

            <Column>

              <Name>ManagedEntityGuid</Name>

              <Type>Guid</Type>

              <XPathExpression Target="DataItem">DataItem/MeId</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>CollectedDate</Name>

              <Type>DateTime</Type>

              <XPathExpression Target="DataItem">DataItem/Dt</XPathExpression>

              <ValueProperty>Value</ValueProperty>

              <AdditionalProcessing>

                <DateTimeToSqlFormat/>

              </AdditionalProcessing>

            </Column>

            <Column>

              <Name>DateKey</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Dk</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TimeKey</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Tk</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ProcessId</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Pid</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>CpuUsage</Name>

              <Type>Double</Type>

              <XPathExpression Target="DataItem">DataItem/Cpu</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>MemoryUsage</Name>

              <Type>Double</Type>

              <XPathExpression Target="DataItem">DataItem/Mem</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>HandleCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Handles</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ThreadCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Threads</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>PageFaultCount</Name>

              <Type>Int</Type>

              <XPathExpression Target="DataItem">DataItem/Faults</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>CpuTime</Name>

              <Type>Long</Type>

              <XPathExpression Target="DataItem">DataItem/CpuTime</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>TotalProcessTime</Name>

              <Type>Long</Type>

              <XPathExpression Target="DataItem">DataItem/tProcessTime</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>IOReadPerSecond</Name>

              <Type>Double</Type>

              <XPathExpression Target="DataItem">DataItem/Read</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>IOWritePerSecond</Name>

              <Type>Double</Type>

              <XPathExpression Target="DataItem">DataItem/Write</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>ProcessName</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Name</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>Description</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Desc</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>CommandLine</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Cmd</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>CommandLineHash</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/Hash</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

            <Column>

              <Name>UserName</Name>

              <Type>String</Type>

              <XPathExpression Target="DataItem">DataItem/User</XPathExpression>

              <ValueProperty>Value</ValueProperty>

            </Column>

          </TableColumns>

          <SqlAuthentication>

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

            <Password>$RunAs[Name='SCDW!Microsoft.SystemCenter.DataWarehouse.SqlAuthenticationActionAccount']/Password$</Password>

          </SqlAuthentication>

        </WriteAction>

      </MemberModules>

      <Composition>

        <Node ID="WA"/>

      </Composition>

    </Composite>

  </ModuleImplementation>

  <InputType>Microsoft.Windows.Server.10.0.DataItemProcessInfo.Type</InputType>

</WriteActionModuleType>