Mohd. Jeffry wrote:

> My boss wants me to do a database growth analysis on our firebird dbs
> starts form January last year. Currently I have no clue how to do
> this. Any hints how to go about this? thanks.

Sounds like a rather unclear request. You should ask him what he really
wants. If he can't give you a clear answer, ask him what the purpose of
the analysis is, i.e. what is he going to use it for. That should give
you the information you need to be able to analyse the appropriate
parameters. You've got several, you know: db file size, size of actual
data content (file size minus slaskspace = size of newly restored db?),
number of records in each table or possibly only in some tables, index
sizes, number of transactions, number of connections, number of users, ...

If he can't give you a clear answer to any of the above, find another job.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64