Azure Analysis Service and Performance

Question

All,

We have an Azure Analysis Service of S0 Pricing Tier in production. I took a look at the Metrics in the Portal due to performance reasons and here is what I found:

[1] Max QPU for Azureaasp1 is frequently 40QPU
[2] Max Memory: Cleaner Memory nonshrinkable for Azureaasp1 is frequently between 7GB and 14GB
[3] Max Memory: Cleaner Memory shrinkable for Azureaasp1 is always 0
[4] Max Memory for Azureaasp1 is between 5GB and 9GB
[5] Max Memory Thrashing for Azureaasp1 is always 0

Does this mean the instance has reached its S0 limits?

Thanks,
grajee

Answer 1

Hi @grajee ,

Welcome to Microsoft Q&A Platform.

The Max metrics referred above are maximum available QPU/Memory and hence does not indicate load on the server. The Max size reflects the Total memory limit. The Hard Memory Limit is always equal to the SKU size (e.g. 10 GB for the S0). Please check this link for some information on the differences. The spikes of memory above Total memory limit would start to trigger high priority cleaning of memory and cause older inactive sessions to be cancelled. Beyond the Hard Memory Limit, the priority bumps up even further, and even active operations and active sessions can get cancelled. DMV's can be used to track the impact for performance, please refer this link for other options.