question

jenniferzen-7686 avatar image
0 Votes"
jenniferzen-7686 asked ZoeHui-MSFT answered

Cube processing failed with memory allocation error

Hi experts,

I have a SSAS tabular cube with an estimated size of 16345 MB.
Its set to have a full processing through sql agent job.
This cube has four fact tables and each fact table has been set to get processed individually ,one after the other, through job steps.
The issue is that it has been failing with memory allocation error at step4 (processing 'factsalesprice' table) resulting in the server fail over.

Can somebody explain it to me how to troubleshoot this issue? what are the steps to be taken to come up with a solution?

1)Does creating partitions on this table and only processing the ones needed would help? is there a way I can first estimate the memory allocated to this table for processing and then partition based on the memory size?

2)I am a developer and was told to redesign the cube if needed. so not sure where to start or how to approach the issue !

few things
1)Database engine and the SSAS services are on the same server (No option to separate them)
2)Increasing the RAM size etc (Again not an option)
3)Its a enterprise edition

please can someone help me?


Thanks

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @jenniferzen-7686,

As you mentioned that you run both the SQL Server relational DB Engine and Analysis Services instances on the same server, it is absolutely crucial to override the defaults for both instances in order to prevent resource contention, memory pressure, and (in the worst case) memory exception errors.

For more information about memory settings, please refer to below blog:

http://byobi.com/2014/04/ssas-memory-configurations-for-common-architectures/

https://docs.microsoft.com/en-us/analysis-services/server-properties/memory-properties?view=asallproducts-allversions

You may have a check if you have limited the DB Engine memory.

You may carefully try to change the memory settings as the article said.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.