Azure Analysis Services - Performance trace / issue

%3CLINGO-SUB%20id%3D%22lingo-sub-1775892%22%20slang%3D%22en-US%22%3EAzure%20Analysis%20Services%20-%20Performance%20trace%20%2F%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1775892%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20are%20struggling%20with%20the%20performance%20in%20Azure%20Analysis%20Services.%20Compared%20with%20the%20old%20SSAS%20%2F%20MDM%20-Cube%2C%20the%20new%20solution%20does%20not%20perform%20well%20enough%20%2F%20price.%20I've%20tried%20to%20look%20at%20the%20various%20fields%2C%20but%20miss%20the%20old%20trace-utility.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20tool%20available%20to%20make%20monitor%20performance%20on%20Azure%20Analysis%20Services%3F%3C%2FP%3E%3CP%3E%2FEdvard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1775982%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Analysis%20Services%20-%20Performance%20trace%20%2F%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1775982%22%20slang%3D%22en-US%22%3Emee%20to.%20but%20what%20do%20you%20mean%20with%20the%20old%20trace-utility%3F%20SQLProfiler%3F%20I%20configured%20AzureAS%20logging%20to%20azure%20monitor%20to%20get%20all%20%22query%20end%22%20events%20for%20analysis....%20but%20you%20can't%20filter%20what%20is%20logged%20in%20detail%20so%20that%20is%20useless%20for%20continous%20monitoring.%20Would%20love%20to%20see%20the%20option%20to%20define%20the%20events%20transfered%20via%20logging%20to%20azure%20monitor%20like%20selecting%20events%20and%20filters%20with%20SQLProfiler..%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1776027%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20Analysis%20Services%20-%20Performance%20trace%20%2F%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1776027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F621334%22%20target%3D%22_blank%22%3E%40jjuelke%3C%2FA%3E%26nbsp%3BYes%2C%20I'm%20thinking%20of%20the%20old%20profiler%2C%20to%20see%20the%20efficiency%20of%20partitions%20etc.%20As%20it%20is%20now%2C%20I'm%20looking%20at%20the%20variables%2C%20but%20don't%20get%20the%20picture%20as%20we%20did%20before.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

5 Replies
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..

@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. 

@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

@mohkumar metrics are on instance level.. they tell you not the details if you want to see query times for sessions/users/identify the low performing dax queries

@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.