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
- Create a dummy database with main tables and indexes
- Put some sample data
- Run the tool. Connect to database
- 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