kql - Kusto memory status for an operation id

Question

I executed the following control command

.set-or-append async XXXX<|fillXXXX()

This returned me an operation id

Now I want to check how much CPU/MEMORY usage (Query stats) happened for this operation id. How can we do that?

Answer 1

When you run the command, you also get the ClientRequestId, and that's what you should use to get the resources used to run the command, :

.show commands
| where StartedOn > ago(1d)
| where ClientActivityId == "KE.RunCommand;9763ec24-910c-4e86-a823-339db440216e"
| where CommandType == "TableSetOrAppend"
| project ResourcesUtilization