Post reply

Tools to calculate db size

  • August 11, 2003 at 6:30 am

    #176307

    Hi there,

    is there a tool out there, which helps me getting rid of estimating db size myself?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • August 14, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • August 15, 2003 at 9:48 am

    #470127

    Frank,

    What do you meen by estimating the db size?

    Size of the existing or a planned db?

    Because (and of cours you now it) you can use sp_spaceused, hp_helpdb, sp_helpfile, dbcc sqlperf(logspace)...

    But for a planned db this is an another story.

    How many tables, how many records/table, which datatype, which will be the average lenght of each and every varchar column, how many columns are NULL, how many indexes, which are the columns to be indexes and blahblahblah.

    Therefore an existing tool....(I can make it for you if you are rich )

    But if you have a remarkable book from Kalen Delaney: Inside Microsoft SQLServer 2000, you can see there a stored proc (in fact there are 4 procs) called sp_EstTableSize (which cales 3 other procs) which gives you an estimate about the size of your table and the indexes.

    Gabor



    Bye
    Gabor

  • August 15, 2003 at 1:27 pm

    #470147

    Hi Gabor,

    quote:

    What do you meen by estimating the db size?

    Size of the existing or a planned db?

    given a db structure an estimation of the size filled with x records

    quote:

    Therefore an existing tool....(I can make it for you if you are rich )

    BOL has some formulas for this. I'm using right now. Well, most of the time I forget to take index space into account.

    But I think, there is also a tool for this. It's called ..ERWin...

    I can post the link on Monday when I'm back in the office.

    quote:

    But if you have a remarkable book from Kalen Delaney: Inside Microsoft SQLServer 2000, you can see there a stored proc (in fact there are 4 procs) called sp_EstTableSize (which cales 3 other procs) which gives you an estimate about the size of your table and the indexes.

    this book is on my shelf. Time to take a closer look once again

    I think this is one of the must have books!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply