Sunday 21 December 2008

EPM Database Maintenance Tasks

After you deploy EPM2007 in your production environment, I would highly recommend you have a SQL maintenance plan in place which includes;

  • Backup
  • Check DB integrity
  • Rebuild Index (-> update statistics)
  • History cleanup
  • Maintenance cleanup

Those who are not hard core SQL DBA’s, contact me and I will email you some simple scripts that will help improve your system performance.

2 comments:

  1. Hi PJ,

    This blog entry is pretty old but yes it's useful in live project cycle..
    Can you please share some useful scripts which can help me to improve Project db performance.
    My Email Id is mohitmanav@rediffmail.com

    Look forward to hear from you..

    Thanks
    Manav

    ReplyDelete
  2. Hi Manav;

    The post below will help.

    http://microsoftepmsolution.blogspot.com/2009/05/how-to-improve-project-server-2007.html

    Regards
    PJ

    ReplyDelete

Please include your email address with comments.