Home
  •  

Access Services: Excessive SQL connection retries

Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLConnectionRetriesMonitor (UnitMonitor)

The average number of retries per connection attempt is too high, this likely means user experience is severely degraded.

Knowledge Base article:

Summary

To get the most current Knowledge Article from the Microsoft TechNet site, visit:

http://go.microsoft.com/fwlink/?LinkId=245546

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

TargetMicrosoft.SharePoint.2016.SPServiceInstance.Access2
Parent MonitorMicrosoft.SharePoint.2016.AccessDataServicesExcessiveSQLConnectionRetries
CategoryAvailabilityHealth
EnabledTrue
Instance NameAccess Services: Data Access Layer
Counter NameAvg. SQL Connection Retry Attempts Per Connection Attempt
Frequency300
Alert GenerateFalse
Alert Auto ResolveTrue
Monitor TypeSystem.Performance.ThresholdMonitorType
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLConnectionRetriesMonitor" Accessibility="Public" Enabled="true" Target="MOSS16Core!Microsoft.SharePoint.2016.SPServiceInstance.Access2" ParentMonitorID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLConnectionRetries" Priority="Normal" TypeID="Performance!System.Performance.ThresholdMonitorType">

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

    <CounterName>Avg. SQL Connection Retry Attempts Per Connection Attempt</CounterName>

    <ObjectName>Access Services: Data Access Layer</ObjectName>

    <InstanceName/>

    <AllInstances>true</AllInstances>

    <Frequency>300</Frequency>

    <Threshold>2.99</Threshold>

  </Configuration>

</UnitMonitor>