How to troubleshoot kusto failures with corelationid

Microsoft

Can I access some logs on why my Kusto query failed? I am unable to troubleshoot the failure

I need to investigate why the query fails, so that I can optimize my query

 

Below is the log of the failure

{"ExecutionTime":108.5802688,"resource_usage":{"cache":{"memory":{"hits":15621348,"misses":2222,"total":15623570},"disk":{"hits":573,"misses":52,"total":625},"shards":{"hitbytes":0,"missbytes":0,"bypassbytes":0}},"cpu":{"user":"00:22:37.3437500","kernel":"00:01:57.7500000","total cpu":"00:24:35.0937500"},"memory":{"peak_per_node":43625738960}},"input_dataset_statistics":{"extents":{"total":2663407,"scanned":5629,"scanned_min_datetime":"2019-10-21T15:39:34.7253024Z","scanned_max_datetime":"2019-10-21T18:05:23.3584546Z"},"rows":{"total":3115175613826,"scanned":2138581223},"rowstores":{"scanned_rows":0,"scanned_values_size":0}},"dataset_statistics":[{"table_row_count":4,"table_size":555}]}

1 Reply

you can see the FailureReason by running ".show queries" and filtering to the ClientActitivityId which is relevant to the execution you're looking into.

if you need assistance with optimizing the query after going through query best practices and making sure all of them have been implemented in your query, please share the query.

 

https://docs.microsoft.com/en-us/azure/kusto/query/best-practices