Database Storage Forecast: Compound Monthly Growth, Overhead & Months Until the Disk Alert (Chart)
This lesson is part of the course
In this lesson
You project Parcelwise's database for the next 12 months, add the overhead the database needs on top of its data, find when the 80 % disk alert will fire and chart it.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Row Size from Column Types & Table Size: Bytes per Row, Rows per Page, GiB Locked
- Index Size & Overhead: B-tree Leaf Pages, Fill Factor & Indexes vs Table Locked
- Database Storage Forecast: Compound Monthly Growth, Overhead & Months Until the Disk Alert (Chart) Locked
- IOPS & Throughput from the Query Mix: Reads, Amplified Writes & the Peak Locked
- Cache Hit Ratio & Buffer Pool Sizing: Working Set, Headroom & the RAM to Buy Locked
- Replicas, Backups & Retention: The Real Storage Footprint of One Database Locked
- Connection Pool Sizing with Little's Law: Busy Connections, Pool per Instance & Limits Locked
- Cost Comparison: Instance Sizes vs Serverless per Month (with a Chart) Locked