IOPS & Throughput from the Query Mix: Reads, Amplified Writes & the Peak
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Row Size from Column Types & Table Size: Bytes per Row, Rows per Page, GiBFree
- Index Size & Overhead: B-tree Leaf Pages, Fill Factor & Indexes vs Table Pro
- Database Storage Forecast: Compound Monthly Growth, Overhead & Months Until the Disk Alert (Chart) Pro
- IOPS & Throughput from the Query Mix: Reads, Amplified Writes & the Peak Pro
- Cache Hit Ratio & Buffer Pool Sizing: Working Set, Headroom & the RAM to Buy Pro
- Replicas, Backups & Retention: The Real Storage Footprint of One Database Pro
- Connection Pool Sizing with Little's Law: Busy Connections, Pool per Instance & Limits Pro
- Cost Comparison: Instance Sizes vs Serverless per Month (with a Chart) Pro