Database Storage Calculator
Size total database storage from tables, indexes, growth and overhead.
About Database Storage Calculator
Indexes frequently rival the table itself in size, so index count belongs in any storage estimate. Compounding growth over the horizon is what determines the provisioning decision. Databases degrade badly when storage fills, so provisioning with 40 per cent headroom is standard rather than cautious.
Formula
Database Storage
Storage = (table + indexes) compounded by growth, with headroom added
- index share
- Indexes commonly add 20 to 100 per cent on top of table size
Worked example
With the default values below, Database Storage Calculator returns Storage Required of 79.346. Change any input above and every figure here is recalculated in your browser.
Inputs used
- Rows in the main tableminimum 0
- 50,000,000
- Average row sizeminimum 0 bytes
- 320 bytes
- Number of indexesminimum 0
- 5
- Index size as a share of table sizeaccepts 0–100 %
- 30 %
- Annual growthaccepts 0–100 %
- 60 %
- Planning horizonaccepts 1–20 years
- 3 years
Results
- Storage Required
- 79.346 GB
- Current Table Size
- 14.901 GB
- Current Index Size
- 4.470 GB
- Current Total Size
- 19.372 GB
- Recommended Provisioned Storage
- 112 GB
Step by step
- 1Values used
- 2Database Storage
- 3Storage Required= 79.346 GB
- 4Current Table Size= 14.901 GB
- 5Current Index Size= 4.470 GB
- 6Current Total Size= 19.372 GB
- 7Recommended Provisioned Storage= 112 GB
Assumptions and limits
- The result is derived only from the 6 inputs listed above. Anything not among them is not part of the calculation.
- In particular, this calculator does not take inflation, tax or fees or charges into account.
- Figures are rounded for display to 3 decimal places, so totals built from several rounded parts can differ slightly from the unrounded arithmetic.
How these calculators are built and tested is described on the Methodology page. If a figure looks wrong, please report it.
Frequently Asked Questions
How is Database Storage calculated?
Storage = (table + indexes) compounded by growth, with headroom added Indexes frequently rival the table itself in size, so index count belongs in any storage estimate. Compounding growth over the horizon is what determines the provisioning decision.
Why does Database Storage matter?
Databases degrade badly when storage fills, so provisioning with 40 per cent headroom is standard rather than cautious.
What values do I need to enter?
This calculator takes 6 inputs: Rows in the main table, Average row size, Number of indexes, Index size as a share of table size, Annual growth, Planning horizon. The pre-filled defaults are a realistic starting point — replace them with figures from your own environment for a result you can act on.