Home
  •  

Performance collection for : PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS

Microsoft.LS.2015.Monitoring.Rule.ReportingPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS (Rule)

Knowledge Base article:

Summary

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

Causes

Locking and contention, or high load can cause time outs for stored procedure execution

Resolutions

Check the database and event logs for errors. If the problem persists, notify your organization's support team.

Element properties:

TargetMicrosoft.LS.2015.Component.Lyss
CategoryPerformanceCollection
EnabledTrue
Instance NameLS:LYSS - Storage Service API
Counter NameLYSS - Total number of failed stored procedure time outs
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.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>