Optimizing your Azure SQL Database workloads
summary
Live demos show a memory‑optimized table with 3 million inserts/sec into a schema‑only durable staging table that later moves to a clustered columnstore for analytics, plus a free read replica serving concurrent reads. Network tuning uses the redirect connection policy (avoid gateway hop) and psping to measure latency. Troubleshooting demos use Query Store, ostress, DAC and telegraph; reducing MAXDOP from 16 to 4 stops worker exhaustion. Data loading with Databricks + Spark achieves the 100 MB/s log generation limit on Hyperscale; single‑thread BULK INSERT from blob stays ~20–30 MB/s.
AI-written summary · about
chapters (4)
- 0:00Start
- 1:53Azure SQL family
- 3:46Spectrum of Database Workloads
- 39:16Data loading in Azure SQL Database
related talks
43mLearn Azure SQL Database through Demos
49mSQL Server on Azure VM - Configuring for Price-Performance
49mAnalytics in SQL Server and Azure SQL Database
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
57mOptimize “All Data” with a Modern Data Warehouse Solution
49mPerformance Features in SQL Server and Azure SQL
51mPerformance Tuning Azure SQL Database
58mFixing poor performance patterns in Azure SQL Database applications