Out of Memory (Analysis Service Database Processing)

Question

I am often running into "Out of Memory Error", while database full process.

Could you please recommend the solution ? What are the tip for Analysis Service maintenance ?

Thanks

Answer 1

Hi @Boiler ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

We need to check which operations are triggering the high memory usage. Adding replicas will help if there are no expensive/runaway queries. Since the out of memory is during refreshes, then it depends on whether enough memory is also in use for active queries. Direct solution can be to use autoscaling feature. Another solution can be to use dynamic partitioning if the issue is due to huge tables in the model. Replicas can be created to separate for query processing and model processing as in this document that might help in improving performance. Also, if you are using gateway, that might be cause in some cases, please check restarting the gateway host.

Additional References:

azure-analysis-services-scheduled-autoscaling
improved-resource-governance-for-azure-analysis-services-2
track-your-azure-analysis-services-processing-times-per-table-f2d3238f81a6
choosing-tier-in-azure-analysis-services

Hope this helps! Please let us know for further queries and we will be glad to assist.

--------------------------------------------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.