SQL Server on Azure VM - Configuring for Price-Performance

on YouTube ↗49m

" summary

Covers concrete configuration choices: choose ebds V5 (double‑sprinkles) for mission‑critical workloads and Azure Boost, use premium ssv2 for most OLTP/IO‑intensive disks, put tempdb on the ephemeral NVMe, set host caching to read‑only for data and none for transaction logs, and watch IO caps — examples include a 112‑core preview target of 400,000 IOPS and 10 GB/s throughput and a common VM limit of 12,800 IOPS; use the SKUR recommendation tool via Azure Data Studio (aka.ms) and measure iops/throughput/latency first.

AI-written summary · about

" chapters (11)

1. 0:00SQL Server on Azure VM
2. 1:53Azure VM sizing and scaling
3. 7:58Azure VM families for SQL
4. 11:06Storage basics for SQL
5. 22:07Workload analysis tool
6. 22:49EBDs V5 and premium SSD V2
7. 25:01Storage for SQL workloads
8. 33:42NVMe vs SCSI performance
9. 38:42IO throttling analysis
10. 43:44Host caching best practices
11. 48:01Best practices and closing

" related talks

• 42mSQL Server on Azure VM - Configuring for price-performanceAditya Badramraju · SQLBits 2023
• 54mAzure Best Practices for Lift and ShiftMichael Wall · Global Azure 2021
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020
• 59mWhat's new on Azure IaaS for SQL Server VMsMarco Obinu · Global Azure Virtual 2020
• 53mOptimizing your Azure SQL Database workloadsSanjay Mishra, Denzil Ribeiro, Dimitri Furman · SQLBits 2020
• 01h 01mSQL Server in the Cloud - The available optionsDennes Torres · Global Azure 2021
• 01h 05mHow to Get the Best Out of Your SQL Server on AzureBjörn Peters · Global Azure 2021
• 18mHow to reduce your SQL Database costs on AzureSulamita Dantas, Leonardo Fonseca · Data Con LA 2021