Google
 

Thursday, July 31, 2008

SQL Server 2005 Analysis Services (SSAS) Server Properties

This may cause issues with PerformancePoint as we don't have control over the processing job, but let's set it to false and see.

Lazy processing allows fast updates to the dimensions. After an update, SSAS processing of aggregations and indexes is initiated in the background. As a result of lazy processing, you might see Analysis Server consuming CPU and disk I/O at times when no user activity is performed. To avoid lazy processing, you can set the ProcessAffectedObjects property as part of a dimension update processing command, causing all aggregations and indexes to be processed as part of the same transaction.

SQL Server 2005 Analysis Services (SSAS) Server Properties

No comments: