Performance Tuning Azure SQL Database
summary
Covers concrete steps for Azure SQL Database tuning: enable Azure SQL Analytics (Log Analytics) to capture deadlocks, waits and timeouts; use Query Performance Insight + Query Store (hourly runtime stats, execution counts) to find high-CPU queries and regressions; note the 45-day window for portal metrics (45-day retention); readable secondaries replicate primary Query Store data so secondary reports don’t show local activity (readable secondaries show primary workload); automatic tuning suggests indexes and can force plans but scripts use NCI names and should be reviewed before applying.
AI-written summary · about
chapters (24)
- 0:00Introduction and background
- 2:08Azure SQL database overview
- 6:25The importance of DBAs
- 7:47Performance tuning essentials
- 9:48Monitoring and metrics
- 12:30Using Azure metric tools
- 15:27Query store fundamentals
- 17:22Query performance insights
- 20:51Analyzing query execution
- 22:56Log analytics configuration
- 24:54Deep dive diagnostics
- 26:25Readable secondary limitations
- 27:51Future of secondaries
- 28:30Managing automatic tuning
- 32:43Manual index recommendations
- 35:16Live demo and portal walkthrough
- 41:20Advanced troubleshooting
- 42:09Query performance walk-through
- 42:32Query store investigation
- 43:11Plan management
- 44:43Addressing secondary warnings
- 45:15Automatic tuning demo
- 46:01Naming and index review
- 47:50Conclusion and Q&A
related talks
49mPerformance Features in SQL Server and Azure SQL
50mSQL Server to Azure SQL: Performance and Availability
53mOptimizing your Azure SQL Database workloads
58mFixing poor performance patterns in Azure SQL Database applications
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
11mOptimize Microsoft SQL Server with Datadog's database monitoring
43mPerformance Tuning, Getting the Biggest Bang for Your Buck
57mYour Performance Tuning Check List