Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Azure Log Analytics or SQL Profiler for AAS?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
James H. Robinson
161
Reputation points
I think you can use both SQL Server Profiler or Azure Log Analytics for Azure Analysis Services logging. But which one is the better option?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,381 Reputation points Microsoft Employee2020-09-23T21:01:59.42+00:00 Hello @James H. Robinson ,
Thanks for the ask and also for using this forum .
It will great if you can eloborate more on what is the problem you are trying to solve . SQL profiler is more on the realtime troubleshooting aspect of things . Log analytics also helps on capture key performance metrics , but it also helps you create reports and alerts on the data .
lLet me know if you have further queries .
Thanks
Himanshu -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 80%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
james.h.robinson.csm@gmail.com 6 Reputation points2020-09-24T18:14:55.333+00:00 We would like to analyze:
- Did the partition processing run successfully, or did it crash?
- If the partition processing did run successfully, did the correct number of rows get processed (inserted)?
- If the partition processing ran successfully and inserted the correct number of rows, how long did it take?
Right now, we are in the dev and test phase, so we want to see it in real time. But later, we want to be able to automate the monitoring.
Also, we are using Logic Apps to process the AAS partitions.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee2020-10-07T17:59:26.547+00:00 Hi @james.h.robinson.csm@gmail.com ,
Sincere apologizes for the delay in response. Your requirement seems to be more related to Azure monitor & Azure Logic apps to track AAS partition processing information. For better and immediate assistance, I would recommend you to please open a new thread with tags 'azure-logic-apps' & 'azure-monitor'. We have our engineers and other community members who would be happy to assist.
Please do share the thread link here for reference once you have opened a new thread. Please let me know if you have further query, would be happy to engage.
Thank you
-
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
2020-10-09T00:02:18.313+00:00 Hi @james.h.robinson.csm@gmail.com ,
Just checking to see if you have got a chance to open a new thread? If so, could you please share the link here for reference.
Thank you
Sign in to comment