DISCOVER
×

How to Estimate the Size of a Database With Volumetrics

Updated April 17, 2017

Database designers need to estimate the size of a future database to allow sufficient disk space to store data. Volumetric data help to predict the size of a database, based on the current business activity and forecast of future growth. They are used to make decisions about necessary hardware and database storage design. Volumetric information, stored in a database, can show the expected rate of storage expansion.

Multiply the total number of fixed-length columns by their byte size to calculate the space that is required for storage of fixed-length columns.

Multiply the total number of variable-length columns by maximum total byte size of all variable-length columns to calculate the space that is required for storage of variable-length columns.

Add the total byte size required for storage of variable-length columns and the number of variable-length columns multiplied by 2 to calculate the variable-length data size. Add total byte size required for storage of fixed-length columns and total byte size required for storage of variable-length columns to calculate the total row size.

Divide "8096" by the total row size to calculate the number of rows per page. Divide the number of rows by the number of rows per page to calculate the number of pages required to store all the rows.

Multiply the number of pages by "8192" to calculate the amount of space required to store the data in the database file.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Alexander Gokhfeld has been writing since 2002. He has written for the monthly business publications "AutoPublish" and "MGRealty." Gokhfeld holds certification in business intelligence infrastructure development as well as a Bachelor of Science in electric engineering from Urban Trans College.