Home
  •  

DB Connection State

Microsoft.ApplicationServer.EventCollector.Event126.TimerReset (UnitMonitor)

This event indicates that a particular database connection threw an exception when trying to open a connection. This will usually be due to a misconfigured connection string, network connectivity issues, or security issues.

Knowledge Base article:

Summary

This event indicates that a particular database connection threw an exception when trying to open a connection. This will usually be due to a misconfigured connection string, network connectivity issues, or security issues.

Resolutions

The Event Collection Service will retry periodically, so if this event is not seen for 10 minutes after initially turning the monitor “Yellow”, then the monitor will be reset to green as it was most likely an intermittent problem.

Element properties:

TargetMicrosoft.ApplicationServer.EventCollectorService
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.SingleEventLogTimer2StateMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ApplicationServer.EventCollector.Event126.TimerReset" Accessibility="Public" Enabled="true" Target="MicrosoftApplicationServerLibrary!Microsoft.ApplicationServer.EventCollectorService" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

    <OperationalState ID="EventRaised" MonitorTypeStateID="EventRaised" HealthState="Warning"/>

    <OperationalState ID="TimerEventRaised" MonitorTypeStateID="TimerEventRaised" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

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

    <LogName>Microsoft-Windows-Application Server-System Services/Admin</LogName>

    <Expression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="UnsignedInteger">126</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">PublisherName</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft-Windows-Application Server-System Services Event Collector</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="String">Params/Param[6]</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">$Target/Property[Type="MicrosoftApplicationServerLibrary!Microsoft.ApplicationServer.EventCollectorService"]/CollectorName$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

    <TimerWaitInSeconds>600</TimerWaitInSeconds>

  </Configuration>

</UnitMonitor>