Olap Cube is taking several hours to build on SQL 2005

Following the performance trend I was thinking to blog some of the best practices for the Project Server.

Some old issues related to the Olap Cube performance are related to the SQL Server flag. After enabling this flags I've seen improvements from several hours to several minutes.

 --Enable the trace flags
DBCC TRACEON(-1,4121,4101)
--Disable the trace flags
TRACEOFF(-1,4121,4101)

and you should see something like this

More details can be found here:

https://support.microsoft.com/kb/942444?wa=wsignin1.0