This rule collects this performance counter for reporting/troubleshooting purposes for the counter: PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS
Total number of failed stored procedure time outs
Locking and contention, or high load can cause time outs for stored procedure execution
Check the database and event logs for errors. If the problem persists, notify your organization's support team.
Target | Microsoft.LS.2015.Component.Lyss |
Category | PerformanceCollection |
Enabled | True |
Instance Name | LS:LYSS - Storage Service API |
Counter Name | LYSS - Total number of failed stored procedure time outs |
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.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS" Enabled="true" Target="Microsoft.LS.2015.Component.Lyss" 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>LYSS - Total number of failed stored procedure time outs</CounterName>
<ObjectName>LS:LYSS - Storage Service API</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>