Project Winproj average time taken for project open

Summary:   This counter tracks the average time taken (in seconds) for a project to open on a Microsoft Project Server application server that uses Microsoft Project Professional. Note that this counter tracks the time taken for a project to open on the server only — it does not include the communication overhead between the client application (in this case Microsoft Project Professional) and the Project Server application server. The average time taken for a project to open is calculated as follows:

Average time taken for project to open = Total time taken for all projects to open / total number of times projects were opened.

Cause:   Possible causes include the following:

• This alert typically occurs when the Project Server application server is overloaded.

• The SQL Server computer that hosts the databases for the Project Server application server is overloaded.

Possible resolutions include the following:

• Review other performance objects, such as Processor, Memory, and PhysicalDisk to determine the performance bottleneck, and upgrade the components that are causing the bottlenecks or consider adding more Project Server application servers to your farm to balance the load.

• If the Project Server application server is not overloaded, the SQL Server computer may be the bottleneck. 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 that run on the same SQL Server computer, 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 SQL Server.