Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SSAS Cube - zero downtime even during cube processing

4 posters

Go down

SSAS Cube - zero downtime even during cube processing Empty SSAS Cube - zero downtime even during cube processing

Post  kajaldas007 Tue Feb 21, 2012 1:43 pm

We recieved a requirement from our client that the cube should be available all the time - even during its processing.

I gathered from different texts that a cube can be queried while it is being processed except the last part of the processing when it actually commits the changes. This last part can take few seconds or even few minutes, during which all the new queries are put on a pending query queue. First of all, if the last part of processing takes few minutes, then it would not be accepted by the client; secondly, I am not sure if there are any side effects associated with the pending queries.

I need some guidance on what are the best practices in such situations. Can cube partitioning be helpful in this context?
kajaldas007
kajaldas007

Posts : 15
Join date : 2012-01-05

Back to top Go down

SSAS Cube - zero downtime even during cube processing Empty Re: SSAS Cube - zero downtime even during cube processing

Post  Mike Honey Sun Feb 26, 2012 11:12 pm

This question is probably asked here:
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

http://www.mangasolutions.com

Back to top Go down

SSAS Cube - zero downtime even during cube processing Empty SSAS Cube - zero downtime even during cube processing

Post  praveenmk Fri Aug 15, 2014 10:11 am

Hi kajaldas007,

I am looking the solution for the same problem - SSAS cube availability.

Did you find a solution for this? If yes, Could you post the solution?

Regards,
Praveen



praveenmk

Posts : 1
Join date : 2014-08-15

Back to top Go down

SSAS Cube - zero downtime even during cube processing Empty Partition Storage Settings

Post  jdobrzen Tue Jan 27, 2015 10:48 am

You need to set your partition setting to be Real Time ROLAP. The below MSDN article describes the different types of partition settings and how ROLAP offers zero latency at the expense of performance, because it is a direct read of the underlying DW tables.

https://msdn.microsoft.com/en-us/library/ms175646.aspx

If performance is an issue (it always is isn't it?) then your next option is Low Latency MOLAP. This will switch from MOLAP to ROLAP during processing, meaning that you will not have the latest data until the processing finishes, but you won't loose the already existing data during processing.

I typically use Automatic MOLAP and have the cube listening for updates to my DW tables (I utilize this for Facts and Dimensions). This way I do not have to build and maintain a processing step in my ETL process. I am also always in MOLAP mode, which means performance is not impacted during processing. There is however latency in the data, because the new data does not become available until processing of the new cache is complete and is swapped out with the old cache.



jdobrzen

Posts : 2
Join date : 2015-01-27

Back to top Go down

SSAS Cube - zero downtime even during cube processing Empty Re: SSAS Cube - zero downtime even during cube processing

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum