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.
The backend might be busy and is unable to respond to requests quickly.
This might be a temporary condition. If the problem persists please ensure that the hardware and software requirements meet the user usage characteristics.
Target | Microsoft.LS.2015.Component.PresenceFocus |
Category | PerformanceCollection |
Enabled | True |
Instance Name | LS:USrv - DBStore |
Counter Name | USrv - Total Dropped Requests |
Frequency | 900 |
Alert Generate | False |
Remotable | True |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
CollectPerfCounter | DataSource | System.Performance.OptimizedDataProvider | Default |
WriteToDB | WriteAction | Microsoft.SystemCenter.CollectPerformanceData | Default |
WriteToDW | WriteAction | Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData | Default |
<Rule ID="Microsoft.LS.2015.Monitoring.Rule.ReportingPC.PresenceFocus.PERF_DBACCESS_DROPPED_REQUESTS" Enabled="true" Target="Microsoft.LS.2015.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>