~/talk

More for less: Cost optimizing your Azure SQL databases

Talkat SQLBits 2024 · 2024-03-19..03-23· [databases]
links:none on file
slides:none on file

Claims that hyperscale is usually the cheapest option for mid‑to‑large databases because it disaggregates compute and storage, supports up to 100 TB, offers 30 named read replicas and 4 H replicas, and lets compute scale independently from storage; serverless (per‑second billing) cuts costs for intermittent spikes; elastic pools save when many DBs have non‑overlapping peaks; Database Fleet Manager (private preview) automates pool rebalance and scale actions; reserved 3‑year capacity can cut compute costs up to ~71% and Azure Hybrid Benefit adds 40–55% license savings.

AI-written summary · about

  1. 0:00Cost optimization intro
  2. 4:02Database categorization theory
  3. 8:44Azure SQL service tiers
  4. 16:25Hyperscale cost benefits
  5. 20:42Compute tier for savings
  6. 28:07Serverless compute tier
  7. 31:42Elastic pools for multiple DBs
  8. 37:45Hyperscale elastic pools costs
  9. 42:19Rebalancing fleet management
  10. 45:28Backup costs and retention
  11. 46:33Discount options
  12. 49:05Cost comparison examples
  13. 50:30Summary
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.