Azure Analysis Service - Memory consumption per Model

Question

We are runing on Tier S2 with a limit of 50GB, but once in a while we exceeded this limitation and so we upgraded temporary to S3 for a few days and then downgraded back again to S2.
After this switch from S2 to S3 and back again to S2, both times the memory consumtion collapsed and sticked to a size below the S2 limitation.

Now I'm trying to figure out what causes this high amount of memory consumtion. But I'm only see the memory of the whole AAS.
I'm not able to add a split for each Model.

As you can see, we have 17 models:

So my questens are :
1.) How can I split the view, so that I can see the memory consomption for each model
2.) How can I figure out which memory is used by the models and which is only used by the system (temporary, working memory, etc.)

Answer 1

Hello @Alex H ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to azcommunity@microsoft.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subscription ID:
Subject : Attn Himanshu
Please let me know once you have done the same.

Update Oct 21

I was reviewing the request and yiou did worked with some one from support . I am sharing the resolution on a very high level so that it can be useful to other team members .
After investigation it was found that the reason behind the high memory utilization on the server is heavy load when compared to the SKU limit.

Thanks
Himanshu

Answer 2

Hey @Alex H ,
An another way can be to set up diagnostic settings on AAS and map it to log analytics.
https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-logging

And via log analytics query, you can get that details split

search * | where ( Type == "AzureDiagnostics" ) | where ( EventClass_s == "QUERY_END" ) | project Category,ResourceGroup,Resource,ResourceType,OperationName,DatabaseName_s,Duration_s,TextData_s,User_s,CPUTime_s  

@HimanshuSinha : Any thoughts on this?