Home
  •  

Project Queue General Percentage SQL Retries Per Hour

Microsoft.SharePoint.Server.2010.Project_Queue_General_Percentage_SQL_Retries_Per_Hour (Rule)

The Queue General Percentage SQL Retries Per Hour Counter measures the number of SQL retries per hour that the Queue hits when it is trying to read jobs from the Project database or write status back.

Knowledge Base article:

Summary

To get the most current Knowledge Article from the Microsoft TechNet site, visit:

http://go.microsoft.com/fwlink/?LinkId=160912

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

TargetMicrosoft.SharePoint.Server.2010.SPServiceInstance.ProjectQueue
CategoryPerformanceCollection
EnabledTrue
Instance NameProjectServer:QueueGeneral
Counter Name\% Sql Retries / Hour
Frequency900
Alert GenerateFalse
RemotableTrue

Member Modules:

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

Source Code:

<Rule ID="Microsoft.SharePoint.Server.2010.Project_Queue_General_Percentage_SQL_Retries_Per_Hour" Enabled="true" Target="Microsoft.SharePoint.Server.2010.SPServiceInstance.ProjectQueue" ConfirmDelivery="false" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

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

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

      <CounterName>% Sql Retries / Hour</CounterName>

      <ObjectName>ProjectServer:QueueGeneral</ObjectName>

      <InstanceName/>

      <AllInstances>true</AllInstances>

      <Frequency>900</Frequency>

      <Tolerance>5</Tolerance>

      <ToleranceType>Percentage</ToleranceType>

      <MaximumSampleSeparation>10</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

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

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

  </WriteActions>

</Rule>