Home
  •  

Total LYSS Database Operation Time out errors

Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS (UnitMonitor)

Knowledge Base article:

Summary

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.2019.Component.Lyss
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.LS.2019.Performance.Double.DeltaThresholdMonitor
RemotableTrue
AccessibilityPublic
Alert Message
[Skype] Total number of failed stored procedure time outs
Perf Object Name:
Perf Counter Name: {0}
Perf Counter Value: {1}
Error Threshold: 10
Warning Threshold: 1
Delta Window Size: 2
Single instance perf counter
Please see the 'Product Knowledge' and the 'Alert Context' tab on Alert Properties view for more information.
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS" Accessibility="Public" Enabled="true" Target="SFBDiscovery!Microsoft.LS.2019.Component.Lyss" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.LS.2019.Performance.Double.DeltaThresholdMonitor" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Alert_Total_number_of_failed_stored_procedure_time_outs">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/CounterName$</AlertParameter1>

      <AlertParameter2>$Data/Context/Value$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS_OverThreshold" MonitorTypeStateID="OverThreshold" HealthState="Error"/>

    <OperationalState ID="Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS_UnderThreshold" MonitorTypeStateID="UnderThreshold" HealthState="Success"/>

    <OperationalState ID="Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Lyss.PERF_LYSS_API_TOTAL_NUMBER_OF_SPROC_EXECUTION_TIME_OUTS_UnderThresholdOverThreshold" MonitorTypeStateID="UnderThresholdOverThreshold" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <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>

    <AllInstances>false</AllInstances>

    <Frequency>900</Frequency>

    <IncludeInstances/>

    <ExcludeInstances/>

    <WarningThreshold>1</WarningThreshold>

    <ErrorThreshold>10</ErrorThreshold>

    <NumSamples>2</NumSamples>

  </Configuration>

</UnitMonitor>