Database size estimation tool

views:

653

answers:

Database size estimation tool

Is there a tool for estimating the size of a database?

I am looking for such a tool, which I can input the estimated tables, row size, data types, indexes and other variables to give me a clue about the size of a yet-non-existing database.

I know MS Sql Server Books Online has a good documentation on how to estimate but I don't want to end up coding it :)

Oracle defines DBA_SEGMENTS where you can check the allocated bytes for a table. It can be much greater than the value suggested by rownum*rowsize as described here.

asalamon74 2009-01-01 10:04:24

thanks, but I am not looking for the size of an existing database

Onur Bıyık 2009-01-01 10:11:25

+1 A:

Sybase PowerDesigner is able to calculate database size from the model, requiring you only to estimate row numbers for each table.

ttarchala 2009-01-01 11:09:39

Wow, just checked the product web page. Thanks!

Onur Bıyık 2009-01-01 14:51:10