Forum Discussion
How to troubleshoot kusto failures with corelationid
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
- Yoni
Microsoft
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