I have created partitions one for each quarter and for processing performance, now I am processing only current and last quarter partition and I am doing ProcessUpdate of dimensions first and then ProcessData followed by ProcessIndex (instead of ProcessFull)
but I found that ProcessUpdate of dimensions is taking too much time and ProcessData, ProcessIndex is also taking almost huge time. I am using SQL Server 2008 R2.
Process Update: Forces a re-read of data and an update of dimension attributes. Flexible aggregations and indexes on related partitions will be dropped. Process Index: Creates or rebuilds indexes and aggregations for all processed partitions. For unprocessed
objects, this option generates an error.
Process Data: Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data.
ProcessUpdate does not discard the dimension storage contents. It applies the changes in a "smart" manner that preserves the fact data in dependent partitions. ProcessFull, does an implicit ProcessClear on all dependent partitions. ProcessUpdate is inherently
slower than ProcessFull since it is doing additional work to apply the changes.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.