DevOps. Monitoring Databases. On-Premise and Cloud environments
summary
Compares on‑prem scripts and open source dashboards with cloud services: AWS CloudWatch plus RDS Performance Insight for query text and a case where 63% CPU masks 40 concurrent sessions causing latency, GCP query insights showing average rows and execution time, Azure Database Explorer hiding query text behind IDs, and tools like PJ Badger, Prometheus and Grafana, New Relic and KQL. Demonstrates a sampling bug: minute metrics miss bursts that per‑second scraping reveals as ~40,000 IOPS.
AI-written summary · about
chapters (12)
- 0:00Introduction to database monitoring
- 2:41Cloud vs on-premise monitoring
- 5:59Tools and utilities overview
- 6:22AWS monitoring with CloudWatch
- 11:22GCP monitoring with Query Insights
- 13:14Azure monitoring solutions
- 15:47Managed solutions like MongoDB Atlas
- 16:30New Relic for transaction monitoring
- 18:24Prometheus and Grafana setup
- 18:45Custom monitoring scripts
- 20:56Troubleshooting high latency issues
- 23:04Conclusion and Q&A
related talks
48mDevOps Discovery: Navigating the Database Landscape- 48mDevOps Discovery: Navigating the Database Landscape
32mManaging Databases in the Cloud in Broken- 48mDevOps Discovery: Navigating the Database Landscape
47mMonitoring Cloud Databases
20mManaging the Challenge of Monitoring Growing, Multi-platform Database Estates
18mManaging Databases in the Cloud is BROKEN!
44mTidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers