EPM Database Maintenance Tasks
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:
- Backup
- Check DB integrity
- Rebuild Index (-> update statistics)
- History cleanup
- Maintenance cleanup
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):
- How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases https://support.microsoft.com/default.aspx?scid=kb;en-us;943345&sd=rss&spid=11373
- Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases https://support.microsoft.com/kb/932744
Comments
Anonymous
January 03, 2008
PingBack from http://www.epmfaq.com/ssanderlin/project-server-2007/maintenance-plans-for-project-server-2007-dbsAnonymous
March 20, 2008
Lately I’ve heard a few requests to improve the Project Server queue performance. For instance some ofAnonymous
July 09, 2008
The comment has been removedAnonymous
August 06, 2008
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).