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

Leave a Reply