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)…

0

Unexpected behaviour for Sharepoint and Project Server and not only

Sometimes it might happen that you run into very random issues and cannot reproduce the problem. This might happen due to the antivirus that is blocking temporary files to scan them and by this it’s putting the files also in read only mode and this is most often the cause for some very strange behaviours…

0