Home
  •  

Performance collection for : PERF_DBACCESS_DROPPED_REQUESTS

Microsoft.LS.2019.Monitoring.Rule.ReportingPC.PresenceFocus.PERF_DBACCESS_DROPPED_REQUESTS (Rule)

Knowledge Base article:

Summary

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

The number of requests that have been dropped by the database layer because they would time out.

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:

TargetMicrosoft.LS.2019.Component.PresenceFocus
CategoryPerformanceCollection
EnabledTrue
Instance NameLS:USrv - DBStore
Counter NameUSrv - Total Dropped Requests
Frequency900
Alert GenerateFalse
RemotableTrue

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.2019.Monitoring.Rule.ReportingPC.PresenceFocus.PERF_DBACCESS_DROPPED_REQUESTS" Enabled="true" Target="SFBDiscovery!Microsoft.LS.2019.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 - Total Dropped Requests</CounterName>

      <ObjectName>LS:USrv - 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>