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 to take your SQL Server implementation to the next level. These SQL Server best practices draw on the extensive experience and expertise from respected developers and engineers at Microsoft, who walk you through the specifics on solving particularly difficult issues.
Happy new year 2008!