July 2, 2014 at 1:31 pm
Hi,
I am currently processing an entire OLAP database that contains 3 cubes. I am currently using "ProcesFull" process option. The whole thing taaskes about 2 hours to process.
1- What will be the optimal scenario for processing? PorcessData follow by ProcessIndex?
2- Can I just process one cube at the time?
3- As of now, I am processing on a Staging server and restoring the database on our Production server. I am trying to optimize our promotion method. Any recommendations?
Thanks a lot for your help,
Rem
July 3, 2014 at 2:31 am
1- What will be the optimal scenario for processing? PorcessData follow by ProcessIndex?
This is the same as doing a process full. Your optimal scenario depends on many things. Is your source a DW that is loaded incrementally? If so then you could look at Process Incremental of the affected partitions. That's just one example. Have a look at the different processing methods here and choose which one suits your environment (http://msdn.microsoft.com/en-us/library/ms174774.aspx
[Quote]
2- Can I just process one cube at the time?
[/Quote]
You can process partition by partition or dimension by dimension. So in short, yes you can.
[Quote]
3- As of now, I am processing on a Staging server and restoring the database on our Production server. I am trying to optimize our promotion method. Any recommendations?
[/Quote]
Again, this would be down to your environment. The best solution for processing would be to use the most appropriate resource at the most appropriate time to get the best results. There are some tweaks and general guidelines that you can follow. There really are many considerations to make. Have a look at this article to begin with: http://technet.microsoft.com/en-gb/library/cc966525.aspx
Also this whitepaper: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=17303
Hope that helps 🙂
July 3, 2014 at 3:11 am
Even if you do not load fully incremental but for example you refresh data from the last 6 months but not before you can process only the relevant partitions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 3, 2014 at 8:03 am
yayomayn (7/3/2014)
1- What will be the optimal scenario for processing? PorcessData follow by ProcessIndex?
This is the same as doing a process full.
True, but recommended best practice is to run ProcessData followed by ProcessIndex rather than just running ProcessFull. The reasons for this are:
1. If, for example, the ProcessIndex fails, you can restart from the point of failure (having fixed the cause of the failure, obviously!) rather than having to run ProcessData again.
2. You can set the processing options differently for each operation, e.g. parallel processing of ProcessData and sequential processing of ProcessIndex..
If the OP's cube takes 2 hours to process, the chances are it is quite large and so they might gain substantially from reason 1 in the event of a processing failure in the ProcessIndex phase.
Regards
Lempster
July 3, 2014 at 9:13 am
True, but recommended best practice is to run ProcessData followed by ProcessIndex rather than just running ProcessFull. The reasons for this are:
1. If, for example, the ProcessIndex fails, you can restart from the point of failure (having fixed the cause of the failure, obviously!) rather than having to run ProcessData again.
2. You can set the processing options differently for each operation, e.g. parallel processing of ProcessData and sequential processing of ProcessIndex..
If the OP's cube takes 2 hours to process, the chances are it is quite large and so they might gain substantially from reason 1 in the event of a processing failure in the ProcessIndex phase.
Regards
Lempster
Good point 🙂
July 4, 2014 at 3:32 am
3- As of now, I am processing on a Staging server and restoring the database on our Production server. I am trying to optimize our promotion method.
you've got these other options for that:
1) Analysis Services database synchronisation functionality (http://msdn.microsoft.com/en-us/library/ms174928.aspx)
this has the advantage of "sending" only the changes made to the data
2) copy and paste the data from one location to another (using Robocopy maybe?)
3) Analysis Services 2008 shared scalable database functionality (http://technet.microsoft.com/en-us/library/cc278097(v=SQL.100).aspx)
Francesco Q.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply