Performance Features in SQL Server and Azure SQL
summary
Covers concrete features and demos: Query Store captures plans and execution stats inside the user database so regressions can be identified, a stored procedure executed 20 times showed durations from about 2.8 ms to ~34.5 ms and a new index produced a different plan that could be forced. Automatic Query Tuning can detect regressions and automatically force the last known good plan and on Azure can create and drop missing indexes. Shows lightweight query profiling with live percent progress and memory grant feedback reducing spills and runtime in the demo.
AI-written summary · about
chapters (20)
- 0:00Start
- 3:37Azure Sql Manage Instance
- 4:24Azure Sql Database
- 9:06Recovery Model in Azure Sql
- 10:25Dynamic Management Views
- 11:13Dmbs
- 14:58What Is Query Store
- 20:21Best Practices
- 22:00Automatic Query Tuning
- 25:21Plan Regressions
- 25:55Adaptive Query Processing
- 27:36Memory Ground Feedback
- 31:46Approximate Count Distinct
- 34:46Lightweight Query Profiling
- 36:0210db Metadata
- 37:46Demo
- 40:02Activity Monitor
- 41:27Show Live Execution Plan
- 42:10Query Store
- 47:27Intelligent Query Processing
related talks
51mPerformance Tuning Azure SQL Database
50mBuilt-in Intelligence with Azure SQL and SQL Server 2022
51mThe 10 things every developer must absolutely know about Azure SQL
50mSQL Server to Azure SQL: Performance and Availability
26mUsing Azure Query Store to Understand PostgreSQL Performance
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi- 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi
53mOptimizing your Azure SQL Database workloads