I want to know the kusto query for getting the CPU consumption and memory usages by adf pipelines above threshold

Kavya Verma 21 Reputation points
2021-12-29T10:16:28.603+00:00

Presently, I am using kusto query language to get the value of CPU consumption and memory utilized above a certain threshold. I have kept the scope as that adf in log analytics workspace. Whenever I run some query I am getting no result, even when the pipeline gives considerable results for these parameters in the metrics section. I have gone through these sources for finding Kusto queries: https://www.cloudsma.com/2018/07/cpu-processes-azure-log-analytics/ https://www.catapultsystems.com/blogs/creating-next-generation-queries-for-cpu-and-memory-kpis-in-log-analytics/ https://pixelrobots.co.uk/2019/06/monitor-your-servers-cpu-usage-using-azure-log-analytics/

And also tried the ones given as the sample queries in log analytics workspace. Besides, on using "Perf" in the queries, an error is thrown stating that "'where' operator: Failed to resolve table or column expression named 'Perf'". How do I get the results using kusto queries?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,829 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,422 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,645 questions