SqlServr Process - \% Processor Time (Sample)

SqlServr_Process_____Processor_Time__Sample__2_8_Rule (Rule)

Knowledge Base article:

Management Pack
Summary
CPU Utilization of SQL Server process
 
Causes
TBD
 
Resolutions
TBD
 
© 2001-2005 Microsoft, all rights reserved.

Element properties:

TargetMicrosoft.Office.LiveCommunicationsServer.2005.Microsoft_Office_Live_Communications_Server_2005_Presence_SQL_Server_Installation
CategoryPerformanceCollection
EnabledTrue
Instance NameProcess
Counter Name\% Processor Time
Frequency900
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{FAC15CB5-F6C9-47E7-A2BE-0ADEBDED58C2}';MOM2005ComputerGroupID={E2E55426-97DE-4004-80E1-290FFB9C42DC}

Member Modules:

ID Module Type TypeId RunAs 
_7EDE552E_C832_4B5E_BA2E_DE65BD5CE042_ DataSource System.Mom.BackwardCompatibility.Performance.FilteredDataProvider Default
CollectPerfData WriteAction Microsoft.SystemCenter.CollectPerformanceData Default
CollectPerfDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="SqlServr_Process_____Processor_Time__Sample__2_8_Rule" Target="Microsoft.Office.LiveCommunicationsServer.2005.Microsoft_Office_Live_Communications_Server_2005_Presence_SQL_Server_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{FAC15CB5-F6C9-47E7-A2BE-0ADEBDED58C2}';MOM2005ComputerGroupID={E2E55426-97DE-4004-80E1-290FFB9C42DC}">
<Category>PerformanceCollection</Category>
<DataSources>
<DataSource ID="_7EDE552E_C832_4B5E_BA2E_DE65BD5CE042_" Comment="{7EDE552E-C832-4B5E-BA2E-DE65BD5CE042}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.Performance.FilteredDataProvider">
<ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<CounterName>% Processor Time</CounterName>
<ObjectName>Process</ObjectName>
<InstanceName>sqlservr</InstanceName>
<Frequency>900</Frequency>
<Expression/>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">
<AlertGeneration>
<GenerateAlert>false</GenerateAlert>
</AlertGeneration>
<InvokerType>1</InvokerType>
</WriteAction>
<WriteAction ID="CollectPerfData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectPerformanceData"/>
<WriteAction ID="CollectPerfDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>
</WriteActions>
</Rule>