Skip to content

Instantly share code, notes, and snippets.

@bpatra

bpatra/querydocdb.sql

Created December 5, 2020 22:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bpatra/14d12e1acfc6edbe27375b7958fcd959 to your computer and use it in GitHub Desktop.
Save bpatra/14d12e1acfc6edbe27375b7958fcd959 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
querydocdb.sql
dependencies
| where timestamp > ago(10h)
| where type == "DOCDB"
| extend requestCharge = todouble(customMeasurements["request-charge"])
| extend docdbkind = customDimensions["kind"]
| extend infolog = customDimensions["infolog"]
| order by timestamp desc
| project timestamp, target, data, resultCode , duration, customDimensions, requestCharge, infolog, docdbkind , operation_Id
| summarize sum(requestCharge) by bin(timestamp, 1s)
| render timechart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment