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

Spread the word!

Who Unfriended me on Facebook?

Leave a Reply

Your email address will not be published. Required fields are marked *