EPM, Enterprise Project Management, Project Server, Project Portfolio Server, SharePoint Services, SharePoint Server
Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005 » Operation   (RSS)

Project Server Statistics

Do you ever need to do an audit of your Project Server 2007 data (prior to a migration, to cleanup unnecessary data, to track the historical volume of data...)? Please find attached a T-SQL script that will retrieve the following information: General Read More...
Posted Tuesday, January 08, 2008 10:23 PM by chrisfie | 0 Comments
Attachment(s): EPM2007 Statistics.txt

SQL Server Best Practices

With the numbers of databases required in EPM 2007, it's key to have a well tuned and maintained database server. The following TechNet page gives a recap of all SQL Server Best Practices : Get the real-world guidelines, expert tips, and rock-solid guidance Read More...
Posted Friday, January 04, 2008 7:05 PM by chrisfie | 2 Comments

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 Read More...
Posted Thursday, October 25, 2007 10:07 PM by chrisfie | 4 Comments
 
Page view tracker