Forum Discussion
memory usage related query
Hi Guys, This below document gives very good output of TOP CPU consuming processes from a workspace; https://www.systemcenterautomation.com/…/cpu-processes-azu…/ Has anyone come across similar qu...
riding on this post - can you combine adding memory + cpu usage per each query being running on analysis ?
let window = AzureDiagnostics
| where ResourceProvider == "MICROSOFT.ANALYSISSERVICES" and Resource =~ "Server Name";
window
| where OperationName has "QueryEnd" or (OperationName has "CommandEnd" and EventSubclass_s == 38)
| where EffectiveUsername_s != "NT AUTHORITY\\SYSTEM"
| where toint(Duration_s) > toint(5000)
| where TimeGenerated > ago(2d)
| project EventSubclass_s,TimeGenerated,StartTime_t,EndTime_t,ServerName_s,OperationName,RootActivityId_g,TextData_s,DatabaseName_s,ApplicationName_s,Duration_s,EffectiveUsername_s,User_s
| order by StartTime_t asc
If its Application Monitoring of CPU/Mem ( this is a PaaS solution) it is done here https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-monitor
You maybe able to combine the two sources (Metrics and Logs) in a workbook, depending on what you wish to achieve?
You maybe able to combine the two sources (Metrics and Logs) in a workbook, depending on what you wish to achieve?