Home
  •  

Access Services: Excessive failed SQL connections

Microsoft.SharePoint.2016.AccessDataServicesExcessiveFailedSQLConnectionsMonitor (UnitMonitor)

The average failed attempts to connect to SQL Azure is too high. This means many of our customer aren’t able to connect to their data.

Knowledge Base article:

Summary

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

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

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

TargetMicrosoft.SharePoint.2016.SPServiceInstance.Access2
Parent MonitorMicrosoft.SharePoint.2016.AccessDataServicesExcessiveFailedSQLConnections
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.DoubleThreshold
RemotableTrue
AccessibilityPublic
RunAsDefault

Source Code:

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

  <Category>AvailabilityHealth</Category>

  <OperationalStates>

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

    <OperationalState ID="OverThreshold2" MonitorTypeStateID="OverThreshold2" HealthState="Error"/>

    <OperationalState ID="OverThreshold1UnderThreshold2" MonitorTypeStateID="OverThreshold1UnderThreshold2" 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>

    <Threshold1>0.1</Threshold1>

    <Threshold2>0.8</Threshold2>

  </Configuration>

</UnitMonitor>