SSAS Cube - zero downtime even during cube processing
4 posters
Page 1 of 1
SSAS Cube - zero downtime even during cube processing
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?
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- Posts : 15
Join date : 2012-01-05
Re: SSAS Cube - zero downtime even during cube processing
This question is probably asked here:
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads
http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/threads
SSAS Cube - zero downtime even during cube processing
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
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
Partition Storage Settings
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.
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
Similar topics
» Cube Processing for Dimension Schema changes
» Error in cube processing using conformed Dimensions
» How do I model this and create SSAS cube from it?
» SSAS Cube structure of SCD Type 2 dimension
» SSAS - Making cube data available after review by power user
» Error in cube processing using conformed Dimensions
» How do I model this and create SSAS cube from it?
» SSAS Cube structure of SCD Type 2 dimension
» SSAS - Making cube data available after review by power user
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum