Performance issues in Fact Build

[seemai]

Hello Cognos ETL tool experts,
I am running into severe performance issues running a fact build. both source & Target is sql server tables. The strange thing is exact same code worked just fine until recently, made no changes & same code is now taking for ever to complete. All memory settings are the same as before too. When I check the log files, its getting stuck at one particular point. It finishes lookup for all members very fact, but is slow at "Processing Fact Data.." step. I am not sure what exactly data manager does at this point. Can anyone help me understand this so that I can troubleshoot it better.
Thanks.

[MFGF]

Hi,

Try enabling Detail, Internal, SQL and Executed SQL logging in the build.  If necessary, change the frequency at which messages are logged during input/output too.  If you lower the input row frequency logging, this should give you a good idea of whether the rows are taking a long time to read, or a long time to process, or a long time to deliver.

Other things to check: Has anyone added an Order By clause to the SQL of the build?
Has anyone changed the properties of the build to merge or aggregate rows?
Has the source database structure been altered (eg has an index been deleted that was previously being used to provide fast data access from the source)?  Has anyone added indexes or constraints to the target table(s) - these will generally slow down delivery.

Good luck!

MF.

[seemai]

Thanks MF for taking time to respond back with your suggestions. Actually all that we had to do to resolve the issue was to run Update STATS on the source table. That solved it! Thanks for your input though!