Project Queue general percentage SQL retries per hour


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_Hour

Summary:   This alert indicates that the number of SQL retries has exceeded the threshold for the past hour.This alert is based on the same performance counter as the "QueueGeneral: % SQL Retries / Day rule.” It also helps to show spikes in SQL retries over a shorter period of time so you can choose to investigate possible causes before customers become aware of a potential problem.

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 determine whether there is excessive network latency between the Project Server application server and the SQL Server computer. If you decide that the network is the bottleneck, resolve accordingly.

  • Monitor the performance objects on the SQL Server computer, such as Processor, Memory, PhysicalDisk, and SQL-specific counters. If the problem is caused by too many applications running on the SQL Server computer used by the Project Server application server, do one of the following:

    • Move the Project application to another SQL Server computer.

    • Move other applications from the SQL Server computer that Project Server is using to another SQL Server computer.

    • Set up a SQL cluster to improve the efficiency of the back-end database.