~/talk

Come see your SQL Perfmon in the cloud

Talkat SQLBits 2024 · 2024-03-19..03-23· [observability, databases]
name:Bob Ward
linkedin:bobwardms
slides:none on file

A new managed service called Database Watcher collects diagnostic telemetry from Azure SQL databases, managed instances, elastic pools and replicas, stores it in a Kusto or Fabric datastore, and surfaces dashboards plus KQL/T‑SQL queries. It ingests samples near real time (ingestion <1s (90th)) across 70+ views 200+ counters, exposes query store and session/weight history, and uses a lightweight remote agent with managed identity and private endpoints. Watcher resources are free, Kusto costs apply, public preview limits 50 targets per watcher, GA tentatively Q4.

AI-written summary · about

  1. 0:00Introduction
  2. 8:59Estate dashboard real-time
  3. 13:12Database perf dashboards
  4. 20:04Q&A
  5. 26:26Architecture data collection
  6. 32:01Querying with KQL SQL
  7. 39:04Cost roadmap docs
  8. 43:17Q&A closing
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.