Access Services: Excessive SQL write failures

Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLWriteFailuresMonitor (UnitMonitor)

The average number of write failures compared to total write attempts is too high, this means the user is either not able to write to their DB or their performance 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=245544

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

Target	Microsoft.SharePoint.2016.SPServiceInstance.Access2
Parent Monitor	Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLWriteFailures
Category	AvailabilityHealth
Enabled	True
Instance Name	Access Services: Data Access Layer
Counter Name	Avg. SQL Write Failures
Frequency	300
Alert Generate	False
Alert Auto Resolve	True
Monitor Type	System.Performance.ThresholdMonitorType
Remotable	True
Accessibility	Public
RunAs	Default

Source Code:

<UnitMonitor ID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLWriteFailuresMonitor" Accessibility="Public" Enabled="true" Target="MOSS16Core!Microsoft.SharePoint.2016.SPServiceInstance.Access2" ParentMonitorID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLWriteFailures" 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 Write Failures</CounterName>

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

    <InstanceName/>

    <AllInstances>true</AllInstances>

    <Frequency>300</Frequency>

    <Threshold>0.1</Threshold>

  </Configuration>

</UnitMonitor>