http://www.sqlservercentral.com/blogs/samvangassql/2011/11/21/ssas-processing-mode-_2800_lazy-aggregations_2900_/

Printed 2014/08/21 04:35AM

SSAS Processing Mode (Lazy Aggregations)

By Sam Vanga, 2011/11/21

Processing mode property of a partition/measure group determines how partitions will be available to users.

Processing mode has two possible options.

clip_image002

For those of you who likes technical lingo, Process Full will internally run Process Data and Process Index before the partition can be queried. If processing mode is set to Lazy Aggregations, partition will be released for user queries after Process Data is completed. Process Index will be executed in the background.

Faster availability of the partition comes with a price. Since aggregations don’t exist while users begin to query the partition they may experience slow performance.

~Sam.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.