More for less: Cost optimizing your Azure SQL databases
summary
Compares service tiers with concrete limits and costs: Business Critical and General Purpose cap at 4 TB and tie compute to storage, Hyperscale separates them so you can have up to 100 TB and independently size vCores, making hyperscale is cheaper than GP for large databases; serverless bills per second and fits intermittent loads so serverless for intermittent workloads; elastic pools save when databases spike at different times; hyperscale pool scaling is ~2–3 minutes; reserved 3‑year discounts up to ~71% and Azure Hybrid Benefit gives ~40–55% savings.
AI-written summary · about
chapters (13)
- 0:00Cost optimization intro
- 4:02Database categorization theory
- 8:44Azure SQL service tiers
- 16:25Hyperscale cost benefits
- 20:42Compute tier for savings
- 28:07Serverless compute tier
- 31:42Elastic pools for multiple DBs
- 37:45Hyperscale elastic pools costs
- 42:19Rebalancing fleet management
- 45:28Backup costs and retention
- 46:33Discount options
- 49:05Cost comparison examples
- 50:30Summary
related talks
18mHow to reduce your SQL Database costs on Azure
17mAutomatic compute scaling with serverless for Hyperscale in Azure SQL Databases
48mBuilding SaaS solutions on Azure SQL Database
01h 01mSQL Server in the Cloud - The available options
20mAzure: Maxmise your bang for Buck
20mChoosing the Right Data Store--An Overview of Azure Data Platform Choices
45mCloud Computing: Cloud in a cost-effective way
20mHow Do I Reduce My Cloud Bill?