Home » Oracle » SQL Server database size estimator

SQL Server database size estimator

A pretty cool tool by Matthew Randle to get an estimation for your SQL Server database size. It’s very useful especially if you’re designing server/storage infrastructure in a new project.

Note: Since most data types and indexes have similar sizes in SQL Server and Oracle, you may want to use this tool for Oracle as well.

How it works

  1. Create a dummy database with main tables and indexes
  2. Put some sample data
  3. Run the tool. Connect to database
  4. It will create a spreadsheet with the current size

Play with row counts so you can estimate the size it’ll have in the future

Download

More

Ned Sahin

Blogger for 20 years. Former Microsoft Engineer. Author of six books. I love creating helpful content and sharing with the world. Reach me out for any questions or feedback.

Leave a Comment