Performance collection for : PERF_DBACCESS_QUEUE_DEPTH

Microsoft.LS.2010.Monitoring.Rule.ReportingPC.PresenceFocus_PERF_DBACCESS_QUEUE_DEPTH (Rule)

Knowledge Base article:

Summary

This rule collects this performance counter for reporting/troubleshooting purposes for the counter: PERF_DBACCESS_QUEUE_DEPTH

The average number of database requests waiting to be executed.

Causes

The backend might be busy and is unable to respond to requests quickly.

Resolutions

This might be a temporary condition. If the problem persists please ensure that the hardware and software requirements meet the user usage characteristics.

Element properties:

Target	Microsoft.LS.2010.Component.PresenceFocus
Category	PerformanceCollection
Enabled	True
Instance Name	LS:USrv - 01 - DBStore
Counter Name	USrv - 000 - Queue Depth
Frequency	900
Alert Generate	False
Remotable	True

Member Modules:

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

Source Code:

<Rule ID="Microsoft.LS.2010.Monitoring.Rule.ReportingPC.PresenceFocus_PERF_DBACCESS_QUEUE_DEPTH" Enabled="true" Target="Microsoft.LS.2010.Component.PresenceFocus" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>PerformanceCollection</Category>

  <DataSources>

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

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

      <CounterName>USrv - 000 - Queue Depth</CounterName>

      <ObjectName>LS:USrv - 01 - DBStore</ObjectName>

      <InstanceName/>

      <AllInstances>true</AllInstances>

      <Frequency>900</Frequency>

      <Tolerance>5</Tolerance>

      <ToleranceType>Absolute</ToleranceType>

      <MaximumSampleSeparation>4</MaximumSampleSeparation>

    </DataSource>

  </DataSources>

  <WriteActions>

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

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

  </WriteActions>

</Rule>