BrainyBeeBrainyBee
ExploreBlogStart Studying
HomeDesigning and Implementing Microsoft DevOps Solutions (AZ-400)Metrics and queries for operations
Lesson246 words

Metrics and queries for operations

Metrics and queries for operations

Measure the user's experience, not the machine's

LayerExamples
User-facingAvailability, latency (p95/p99), error rate
InfrastructureCPU, memory, disk, network

Infrastructure metrics explain why; user-facing metrics tell you whether anyone is suffering. Alert on the second and diagnose with the first — a CPU alert at 3am for a service nobody is using is how alert fatigue starts, and alert fatigue is how a real page gets ignored.

Percentiles, not averages

An average hides the tail. A service averaging 200 ms may have a p99 of 8 seconds, which is a meaningful fraction of users having a bad time — and averages get better as traffic grows even while the tail worsens. Report p95 and p99.

Kusto Query Language

Azure Monitor logs are queried with KQL, which the objective names explicitly:

kusto
requests | where timestamp > ago(1h) | summarize p95 = percentile(duration, 95) by name | order by p95 desc

The pattern to recognise: filter → summarise → order. Being able to read a query of this shape is worth more than memorising operators.

Actionable alerting

An alert should name something a human can do. "CPU above 80%" is a symptom; "checkout error rate above 2% for 5 minutes" is a problem with an owner. Every alert that fires without requiring action reduces the credibility of every alert that follows.

Primary sources

  • https://learn.microsoft.com/en-us/azure/azure-monitor/overview
All Designing and Implementing Microsoft DevOps Solutions (AZ-400) Study Resources

Related Notes

  • Agent and runner infrastructure421 words
  • Agent and runner infrastructure — quick notes150 words
  • Alerting on pipeline events255 words
  • Alerting on pipeline events — quick notes94 words
  • Analyzing usage and application performance241 words
  • Analyzing usage and application performance — quick notes73 words
  • Appropriate access levels217 words
  • Appropriate access levels — quick notes85 words
  • Automating container scanning277 words
  • Automating container scanning — quick notes96 words
  • Automating documentation from Git history191 words
  • Automating documentation from Git history — quick notes55 words

Ready to study Designing and Implementing Microsoft DevOps Solutions (AZ-400)?

Practice tests, flashcards, and all study notes — free, no sign-up.

Start Studying

Ready to study Designing and Implementing Microsoft DevOps Solutions (AZ-400)?

Practice tests, flashcards, and all study notes — free, no sign-up needed.

Start Studying — Free
Designing and Implementing Microsoft DevOps Solutions (AZ-400) ResourcesExplore All HivesBlogHome

© 2026 BrainyBee. Free AI-powered exam prep.