After you deploy EPM 2007 in your production environment, I highly recommend you have a SQL maintenance plan in place.
Maintenance tasks that should be in this plan include:
For more information on this subject please check the standard SQL documentation as well as these two articles for SharePoint databases (thank you Chris Gideon for the pointers):
PingBack from http://www.epmfaq.com/ssanderlin/project-server-2007/maintenance-plans-for-project-server-2007-dbs
Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some of
We created a maintenance plan as mentionned in the referred articles and it takes around 20 min. to execute. The environment is pretty small, not even 10 projects, no project workspace. How long is it gonna take on a production environment ?
I am wondering if anybody has noticed the same behaviour ?
I would recommend you deploy the newly released Infrastructure Update to leverage the latest performance gains.
As far as the maintenance plan goes, depending which one you implemented it should be run offpeak during week-ends (defrag for instance).