Forum Discussion

EdvardGundersen's avatar
EdvardGundersen
Copper Contributor
Oct 13, 2020

Azure Analysis Services - Performance trace / issue

Hi, 

we are struggling with the performance in Azure Analysis Services. Compared with the old SSAS / MDM -Cube, the new solution does not perform well enough / price. I've tried to look at the various fields, but miss the old trace-utility. 

 

Is there any tool available to make monitor performance on Azure Analysis Services?

/Edvard

AMA

5 Replies

  • jjuelke's avatar
    jjuelke
    Copper Contributor
    Oct 13, 2020
    mee to. but what do you mean with the old trace-utility? SQLProfiler? I configured AzureAS logging to azure monitor to get all "query end" events for analysis.... but you can't filter what is logged in detail so that is useless for continous monitoring. Would love to see the option to define the events transfered via logging to azure monitor like selecting events and filters with SQLProfiler..
    • mohkumar's avatar
      mohkumar
      Copper Contributor
      Oct 13, 2020

      jjuelke you can use Metrics from portal that will give you detailed information. here is additional information on how to do? https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-monitor

      • EdvardGundersen's avatar
        EdvardGundersen
        Copper Contributor
        Oct 13, 2020

        mohkumar - Agree, and I have a lot of measures within dashboards, but still - the performance is suffering. I can't really get the bottleneck... Most likely due to knowledge, but...

         

        There is always possible to improve by increasing QPU/Cache, but the cost / performance is too high. 

    • EdvardGundersen's avatar
      EdvardGundersen
      Copper Contributor
      Oct 13, 2020

      jjuelke Yes, I'm thinking of the old profiler, to see the efficiency of partitions etc. As it is now, I'm looking at the variables, but don't get the picture as we did before. 

Resources