Error message in Project Center due to performance issue

Symptoms

When you try to access to the Project Center view in Project Web Access, you get the following message:

Project Center cannot access the project(s) you're trying to view. It is mostly likely that you either don't have permissions ...

Cause

This message can appear when the web service is waiting for a long time to return some SQL data from the server.

If a timeout error occurs when Project Server is trying to get data to display the content of the Project détails view, you can see in the ULS log the following information:

PSI: PWA.ProjectGetProjectDetailsForGrid  SqlException occurred in DAL:
<Error>
<Class>11</Class>
<LineNumber>0</LineNumber>
<Number>-2</Number>
<Procedure></Procedure>
<Message>  System.Data.SqlClient.SqlError: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  </Message>

When you trace with SQL Profiler, you detect a specific query takes a lot of time to be executed.
If you extract this query, you execute it in a new query against the Published database and you display the Execution Plan, you detect the main Cost% comes from Seek command on different tables with clustered indexes.

This means the root cause of the timeout is certainly due to a high fragmentation of indexes on these tables.

Resolution

To resolve the issue, you can execute the SProc provided in the article http://support.microsoft.com/kb/943345/ against the Published database.

In general, it is strongly recommend to create a Maintenance plan on Project Server databases.
Propiedades

Id. de artículo: 2786167 - Última revisión: 26 mar. 2013 - Revisión: 1

Comentarios