Nuestro buen amigo Juan Pablo Pussacq nos comparte su artículo:
This article is the first of a series of articles on the improvement in the performance of Project Server. This first document describes good practices of the Project Server 2007 database maintenance, which primarily includes:
The verification of the integrity of the BD
Defragmenting indexes by reorganizing them or rebuilding them.
The configuration of the "fill factor"
Monitoring the size of the database
Points 1 and 2 is explained in detail in the document. For more information on paragraphs 3 and 4, see the following article: http://surpoint.blogspot.com.ar/2012/03/sharepoint-2007monitoreo-de-la-la-base.html
It includes tests in an environment of these features:
Project Server 2007 Services Pack 3
Windows SharePoint Services 3.0 with Services Pack 3
SQL Server 2005 with Service Pack 4 (important, do not apply this procedure if SQL Server SP2 was not applied )
Fernando García Loera (Community Program Manager – Latin America Region)