Home
  •  

Registrar Database: Database Queue Depth

Microsoft.LS.2019.Monitoring.UnitMonitor.ThresholdPC.Registrar.PERF_REGDBACCESS_QUEUE_DEPTH (UnitMonitor)

Knowledge Base article:

Summary

The average number of database requests waiting to be executed.

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.Registrar
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.LS.2019.Performance.Double.ConsecutiveThresholdMonitor
RemotableTrue
AccessibilityPublic
Alert Message
[Skype] The average number of database requests waiting to be executed.
Perf Object Name:
Perf Counter Name: {0}
Perf Counter Value: {1}
Error Threshold: 2000
Warning Threshold: 1000
Consecutive Samples Repeat Count: 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.Registrar.PERF_REGDBACCESS_QUEUE_DEPTH" Accessibility="Public" Enabled="true" Target="SFBDiscovery!Microsoft.LS.2019.Component.Registrar" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.LS.2019.Performance.Double.ConsecutiveThresholdMonitor" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Alert_The_average_number_of_database_requests_waiting_to_be_executed.">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

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

      <AlertParameter2>$Data/Context/SampleValue$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

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

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <CounterName>USrv - Queue Depth</CounterName>

    <ObjectName>LS:USrv - REGDBStore</ObjectName>

    <AllInstances>false</AllInstances>

    <Frequency>60</Frequency>

    <IncludeInstances/>

    <ExcludeInstances/>

    <WarningThreshold>250</WarningThreshold>

    <ErrorThreshold>500</ErrorThreshold>

    <NumSamples>1</NumSamples>

  </Configuration>

</UnitMonitor>