SSAS consume a lot of memory

[kimpanu]

Hi,

I am analyzing why my SSAS server is consume a lot of memory sometimes what i can see it is not when the model is processing. I have run the dmv Memory usage to find what in SSAS service is take all the memory, and we talk about 115GB memory. My model is only 6GB when loaded in memory.

The result of running memory usage can you see below. The what i can see from it, it is the OBJECT ID Big and Small the consume all the memory togeheter. So my question is, what is that? And how can i reduce the consume of memory?

Result of memory usage dmv

[kimpanu]

Hi @Anonymous ,

Yes that i understand but what trigger the internal things to consume a lot of memory. Nobody query data and no process of the cube is running then. So i cant understand what is uses all the memory. Or modell is only consume 6GB in-memory so i cant understand why it will take 120gb memory when nobody dosent do anything.

After i read the article you link i cant understand what i should adjust to reduce memory use?

[Anonymous]

Hi @kimpanu ,

“OBJECT ID Big” and ‘OBJECT ID Small’ may refer to the internal identifiers of large and small objects that occupy memory in SSAS.

SSAS allows memory settings to be configured to optimize performance. You can adjust HardMemoryLimit to set the maximum memory threshold or change VertiPaqPagingPolicy to manage how SSAS handles memory paging.

Below is the link about optimizing memory will help you:

Optimizing memory settings in Analysis Services - SQLBI

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.