Home
  •  

Process (Sql Server) Processor Time

Microsoft.Office.Sharepoint.Server.2007.Process_Sql_Server_Processor_Time (Rule)

This rule uses the \% Processor Time counter to determine the percentage of elapsed time for all of the process threads used by the processor to execute instructions. An instruction is the basic unit of execution in a computer, a thread is the object that executes instructions, and a process is the object created when a program is run. Code executed to handle some hardware interrupts and trap conditions are included in this count.

Knowledge Base article:

Summary

This rule uses the % Processor Time counter to determine the percentage of elapsed time for all the process threads that the processor uses to execute instructions. An instruction is the basic unit of execution in a computer, a thread is the object that executes instructions, and a process is the object created when a program is run. This count includes code that is executed to handle some hardware interrupts and trap conditions.

© 2000-2007 Microsoft Corporation, all rights reserved.

Element properties:

TargetMicrosoft.Office.Sharepoint.Server.2007.MOSS.Server
CategoryPerformanceCollection
EnabledTrue
Instance NameProcess
Counter Name\% Processor Time
Frequency3600
Alert GenerateFalse
RemotableTrue

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource System.Performance.OptimizedDataProvider Default
CollectData WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
DataWarehousePublishData WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default

Source Code:

<Rule ID="Microsoft.Office.Sharepoint.Server.2007.Process_Sql_Server_Processor_Time" Enabled="onEssentialMonitoring" Target="Microsoft.Office.Sharepoint.Server.2007.MOSS.Server" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Performance!System.Performance.OptimizedDataProvider">

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

      <CounterName>% Processor Time</CounterName>

      <ObjectName>Process</ObjectName>

      <InstanceName>sqlservr</InstanceName>

      <AllInstances>false</AllInstances>

      <Frequency>3600</Frequency>

      <Tolerance>10</Tolerance>

      <ToleranceType>Percentage</ToleranceType>

      <MaximumSampleSeparation>2</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="CollectData" TypeID="SystemCenter!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="DataWarehousePublishData" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>