Re: Regarding the space requirement of a disk

On 2005-07-26, hafeez_splendid_at_yahoo.co.in <hafeez_splendid_at_yahoo.co.in> wrote:
> Hi all,
> I have been assigned to create a formula which should compute
> the disk size which should be allotted to some database and it should
> not fall short for some period.
>
> Iam calculating the size of the data for that period according to the
> given requirement but i have some doubts regarding other things which
> i have to consider for disk space.
>
>
> Can you please explain
> 1. what is the approach i have to take to estimate the sizes of
> indexes which will be formed for the user tables ( and i dont know for
> how many tables the index will be formed ). Do i have to take an
> optimistic thinking that every table will possess index.

If you don't know, how are we supposed to know?

> 2.What size i have to allocate for the back up files . Do i have
> to take the complete data size into consideration.

depends on how long you want to retain backups, how often you do them, if you take incremental backups....

> It would be better if more information provided on this topic.
> Please help me in this .

It's probably more expensive to calculate such a figure, which then, will still be at best an estimation, than to just throw some disk space at the server and if it is not sufficient to add more.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/