SQL Server to Azure SQL: Performance and Availability
summary
Covers concrete migration choices: backup cadence (full weekly, log every 5–10 min, diff every 12 h) and RAGRS geo-restore, service tiers (general purpose vs business critical and hyperscale up to 100 TB), SLA math (99.99% ≈ <26 min/year). Shows live demos using ostress, Azure Data Studio/PowerShell, DMVs and Query Store: scale a General Purpose 2 vCore DB to 8 vCores and drop a repeated query from ~1m30s to sub-second. Describes automatic tuning using Query Store and Azure Monitor integration.
AI-written summary · about
chapters (24)
- 0:00Introduction
- 1:17Agenda
- 1:48Azure SQL
- 3:34Capabilities
- 4:22Backup and Restore
- 6:56General Purpose
- 8:37Business Critical
- 10:07Demo
- 12:58Secondary replicas
- 15:06Service tiers
- 15:48Zone redundant configuration
- 19:25Availability and consistency
- 20:39Whats next
- 22:46Wrap up
- 23:10Performance
- 23:51Capacity
- 26:35Tempdb
- 27:30Database Configuration
- 28:16Files and File Groups
- 30:05Monitoring and Troubleshooting
- 34:08Performance Problems
- 40:26Monitoring Performance
- 46:19Automatic Tuning
- 47:36Resources
related talks
49mSQL Server on Azure VM - Configuring for Price-Performance
47mPerfecting business continuity for Azure SQL DB
49mPerformance Features in SQL Server and Azure SQL
56mMigrate Databases to the Cloud - Why, How and Best Practices
50mSQL Modernization Journey with Tools, Assets & Migration Best Practices
54mAzure Best Practices for Lift and Shift
42mSQL Server on Azure VM - Configuring for price-performance
50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engi