Forum Discussion
memory usage related query
Two things:
1. You need to tell Log Analytics to collect Perf (or Linux Perf counters) that relate to a process and memory.
Log Analytics - Advanced Settings - Data - "Windows Perf Counter" then type a filter like "process(*)" to see the list
2.
Use the Top query option, like this (sample below) which shows a Top 10 for memory kbytes
Go to Log Analytics and run query
Perf
| where ObjectName == "Process"
| where CounterName == "Used Memory kBytes"
| summarize by CounterValue, InstanceName
| top 10 by CounterValue desc
https://docs.microsoft.com/en-us/azure/kusto/query/topoperator
From that link you provided, you would need to change the Countername to match the one you selected in step 1 https://www.systemcenterautomation.com/2018/07/cpu-processes-azure-log-analytics/
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? - Do you mean CPU and Perf data of the query itself, or CPU and Memory from the resource you are monitoring?
You need to enable this for Workspace Query auditing on CPU & Memory:
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/query-audit
or
However you can see this info at runtime in the UI after you run a query, just use the double down arrows to the right of the count of rows to display metrics.first - i appreciate your fast replay on this thread,
Yes -i would like to see the CPU and Perf data of the query itself.
how can this be done using my query ?
To see the data, just click the down arrows after you run any query. Or to log the data and to query it as well, you need to enable the feature I mentioned in my reply. Look at this demo (attached), the first part is using the UI, the second assumes you enable auditing and have LAQueryLogs available to you.
Sarah_Young , does a nice write up here of the audit feature: https://techcommunity.microsoft.com/t5/azure-sentinel/auditing-azure-sentinel-activities/ba-p/1718328
