A trigger for a number of connections. We don't want this firing for a very small number of users.
To get the most current Knowledge Article from the Microsoft TechNet site, visit:
http://go.microsoft.com/fwlink/?LinkId=245547
View all current alerts from this object using this link:
View Alerts
Target | Microsoft.SharePoint.2016.SPServiceInstance.Access2 |
Parent Monitor | Microsoft.SharePoint.2016.AccessDataServicesExcessiveFailedSQLConnections |
Category | AvailabilityHealth |
Enabled | True |
Instance Name | Access Services: Data Access Layer |
Counter Name | Avg. SQL Connection Retry Failures Base |
Frequency | 300 |
Alert Generate | False |
Alert Auto Resolve | True |
Monitor Type | System.Performance.ThresholdMonitorType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveFailedSQLConnectionsNumberOfConnectionsTrigger" Accessibility="Public" Enabled="true" Target="MOSS16Core!Microsoft.SharePoint.2016.SPServiceInstance.Access2" ParentMonitorID="Microsoft.SharePoint.2016.AccessDataServicesExcessiveFailedSQLConnections" 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 Failures Base</CounterName>
<ObjectName>Access Services: Data Access Layer</ObjectName>
<InstanceName/>
<AllInstances>true</AllInstances>
<Frequency>300</Frequency>
<Threshold>1000</Threshold>
</Configuration>
</UnitMonitor>