Come see your SQL Perfmon in the cloud
summary
Database Watcher is a managed monitoring pipeline that pulls query store, >200 perf counters and 70+ views from databases, managed instances, elastic pools and replicas into a custo data store (Azure Data Explorer / Fabric) where dashboards and KQL or T-SQL ad‑hoc queries run. Agents run remotely with private endpoints, typical ingestion is <1s 90th percentile (max single‑digit seconds), sampling as frequent as 10s, default retention one year, Watcher resources are free and initial limit is 50 targets per watcher.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 8:59Estate dashboard real-time
- 13:12Database perf dashboards
- 20:04Q&A
- 26:26Architecture data collection
- 32:01Querying with KQL SQL
- 39:04Cost roadmap docs
- 43:17Q&A closing
related talks
49mCome see your SQL Perfmon in the cloud
24mDevOps. Monitoring Databases. On-Premise and Cloud environments
11mMonitor Microsoft Azure SQL with Datadog's Database Monitoring
43mMoving Up the Monitoring Stack
44mBenchmarking in the cloud
11mOptimize Microsoft SQL Server with Datadog's database monitoring
50mYes, You Should Monitor Azure SQL Database
51mPerformance Tuning Azure SQL Database