Tools to calculate db size
-
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] -
This was removed by the editor as SPAM
-
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 -
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]
) you can use sp_spaceused, hp_helpdb, sp_helpfile, dbcc sqlperf(logspace)...
)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply