Project Queue general percentage SQL retries per day
Applies to: Project Server 2013, Project Server 2010
Topic Last Modified: 2013-12-18
Element ID / Rule Name: Project_Queue_General_Percentage_SQL_Retries_Per_Day
Summary: This alert occurs if the queue is hit with a number of SQL retries when it is trying to read jobs from the Microsoft Project database or write status back.
Note that this does not include SQL retries that may result from individual jobs being processed — but still gives a fair idea that there is something potentially wrong with the Project Server-to-SQL interaction.
Cause: Possible causes include the following:
The network connection between the Project Server application server and the SQL Server computer may be a bottleneck (if they are on different computers).
The SQL Instance that Project Server connects to may be overloaded.
Possible resolutions include the following:
Use a network Ping to verify whether there is excessive network latency between the Project Server application server and the SQL Server computer. If it is determined that the network is the bottleneck, resolve accordingly.
Monitor the performance objects on the computer that is running SQL Server, such as Processor, Memory, PhysicalDisk, and SQL-specific counters. If the problem is caused by too many applications that run on the SQL Server computer used by the Project Server application server, do one of the following:
Move the Project application to another computer that is running SQL Server.
Move other applications from the instance of SQL Server that Project Server is using to another instance of SQL Server.
Set up a SQL Cluster to improve the efficiency of the back-end database.