Estimating database size from DDL

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

Estimating database size from DDL

Author

Topic

stonebreaker
Yak Posting Veteran

92 Posts

Posted - 2010-06-04 : 11:50:48

We are designing a new data warehouse. Is there a tool out there that is capable of looking at the database structure and estimating the database growth over time based on a set of input parameters (applications per unit time, for example)?

Stonebreaker
The greatest obstacle to discovery is not ignorance - it is the illusion of knowledge.
-Daniel Boorstin

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2010-06-04 : 12:17:45

Excel formulae?

stonebreaker
Yak Posting Veteran

92 Posts

Posted - 2010-06-04 : 12:50:12

Yeah, something like that. I was hoping there was a tool that maybe populated an excel spreadsheet with table names automatically, or something similar, since there are a BUNCH of tables we need to estimate.

Stonebreaker
The greatest obstacle to discovery is not ignorance - it is the illusion of knowledge.
-Daniel Boorstin

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2010-06-08 : 06:52:26

This may give you a head-start. you'll then need to apply volumes to each table

select a.name, b.name, b.xtype, b.length, c.name
from sysobjects a
inner join syscolumns b
on b.id = a.id
inner join systypes c
on c.xtype = b.xtype
where a.xtype = 'U'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources