Forum Discussion

srinipi's avatar
srinipi
Icon for Microsoft rankMicrosoft
Oct 21, 2019

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

  • 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

Resources