Access Services: Trigger for excessive SQL write failures

Microsoft.SharePoint.2016.AccessDataServicesExcessiveSQLWriteFailuresNumberOfConnectionsTrigger (UnitMonitor)

A trigger for the number of SQL write failures. Fires if there are 1000 within a 5 minute interval.

Knowledge Base article:

Summary

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

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

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.AccessDataServicesExcessiveSQLWriteFailuresNumberOfConnectionsTrigger" 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>1000</Threshold>

  </Configuration>

</UnitMonitor>