A warning state for this Monitor indicates that the percentage of SQL retries has exceeded the acceptable threshold for the past day.
To get the most current Knowledge Article from the Microsoft TechNet site, visit:
http://go.microsoft.com/fwlink/?LinkId=160911
View all current alerts from this object using this link:
View Alerts
Target | Microsoft.SharePoint.Server.2010.SPServiceInstance.ProjectQueue |
Parent Monitor | System.Health.PerformanceState |
Category | PerformanceHealth |
Enabled | True |
Instance Name | ProjectServer:QueueGeneral |
Counter Name | \% Sql Retries / Day |
Frequency | 21600 |
Alert Generate | False |
Alert Auto Resolve | True |
Monitor Type | System.Performance.ThresholdMonitorType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.SharePoint.Server.2010.SPServerInstance.ProjectQueue.QueueGeneralPercentageSQLRetriesPerDay" Accessibility="Public" Enabled="true" Target="Microsoft.SharePoint.Server.2010.SPServiceInstance.ProjectQueue" ParentMonitorID="Health!System.Health.PerformanceState" Priority="Normal" TypeID="Performance!System.Performance.ThresholdMonitorType">
<Category>PerformanceHealth</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>% Sql Retries / Day</CounterName>
<ObjectName>ProjectServer:QueueGeneral</ObjectName>
<InstanceName/>
<AllInstances>true</AllInstances>
<Frequency>21600</Frequency>
<Threshold>2</Threshold>
</Configuration>
</UnitMonitor>