Memory spikes in Analysis Services

Billy Duong 0

We've recently been experiencing large memory spikes while processing a few of our tabular models on different Azure Analysis Services instances.

There were no major changes to the data, so we were not able to determine why it was happening.

The issue then went away on 01/26 after a week of doing so. This coincided with a maintenance window on Analysis Services in the West US region (the region we use).

Anyone else experience similar issue and/or know if the maintenance was what actually resolved this or just coincidental timing?

phemanth 13,465 Reputation points Microsoft Vendor

2025-01-30T04:41:23.1333333+00:00
@Billy Duong

Thanks for the question and using MS Q&A platform.

It Seems like you've been dealing with some frustrating memory spikes in Azure Analysis Services. It's good to hear that the issue resolved itself after the maintenance window, but I understand why you'd want to know if the maintenance was the actual fix or just a coincidence.

Memory spikes in Azure Analysis Services can be caused by various factors, including complex DAX calculations, large data volumes, or inefficient data models

Maintenance windows can sometimes resolve these issues if they involve updates or optimizations to the underlying infrastructure.

Here are steps you can take to monitor and optimize memory usage in Azure Analysis Services:

Monitor Memory Usage: Use the Azure portal to monitor memory usage and identify any patterns or specific times when spikes occur.

Optimize Data Models: Simplify your data models and reduce the number of calculated columns and tables if possible.

Review DAX Queries: Ensure that your DAX queries are optimized and not causing excessive memory consumption.

Scale Up Resources: If memory issues persist, consider scaling up your Azure Analysis Services instance to a higher tier with more memory

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you
phemanth 13,465 Reputation points Microsoft Vendor

2025-01-31T01:29:57.5466667+00:00

@Billy Duong We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Memory spikes in Analysis Services

Your answer