Overview
Learn to effectively monitor and troubleshoot Azure SQL databases in this comprehensive conference talk. Explore graphical tools like Azure portal and DMVs to track key metrics such as CPU, DTU, Data IO, and database size percentage. Discover how to configure SQL Database for storing resource usage, workers, sessions, and connectivity data in Azure Storage, Azure Event Hubs, or Azure Log Analytics. Gain insights into setting up event-based alarms and leveraging intelligent performance features. Through demonstrations, master the creation of action groups, alerts, and diagnostic settings, and learn to utilize Log Analytics for enhanced database management.
Syllabus
Intro
Azure SQL Database
Azure Monitor
Demo
Create Action Group
Create Alert
Diagnostic Settings
Workspace
Diagnostic Matrix
Intelligent Performance
Alerts
Log Analytics
Demonstration
Taught by
PASS Data Community Summit