CODEWITHSUNDEEP
powerbiazure-data-explorerkql
Milo_Dev
Milo_Dev

Reputation: 425

Azure Data Explorer - Measuring the Cluster performance /impact

Is there a way to measure the impact to Kusto Cluster when we run a Query from Power BI. This is because the Query I use in Power BI might get large data even if it is for a limited time range. I am aware of setting - limit Query result record ,but I would like to measure the impact to Cluster for specific queries .

Do I need to use the metrics under - Data explorer monitoring. Is there a best way to do it and any specific metrics . Thanks.

Upvotes: 0

Views: 524

Answers (1)

Yoni L.
Yoni L.

Reputation: 25925

You can use .show queries or Query diagnostics logs - these can show you the resources utilization per query (e.g. Total CPU time & memory peak), and you can filter to a specific user or application name (e.g. PowerBI).

Upvotes: 2

Related Questions