After you deploy EPM2007 in your production environment, I would highly recommend you have a SQL maintenance plan in place which includes;
- 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.