Oct 13 2020 09:05 AM - last edited on Feb 05 2021 01:14 PM by Eric Starker
Oct 13 2020 09:05 AM - last edited on Feb 05 2021 01:14 PM by Eric Starker
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
Oct 13 2020 09:09 AM
Oct 13 2020 09:13 AM
@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.
Oct 13 2020 09:15 AM
@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
Oct 13 2020 09:18 AM
Oct 13 2020 09:19 AM
@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.