How do we calculate database growth?
I have situation where I have to calculate growth of the database. I am new to this firm. We implemented new indexes on production database where it took all freespace that is left. So we increased tablespace since we still have some more indexes to compile. Unfortunately, we ran out of space on server. I have requested more space on server i.e 50% of current database size. Obviously, there are other databases on the same server and management wants to know why I need that much of space. Now my question is
1. How do we calculate database growth?
2. How do we know how much tablespace is needed for particular index.
3. Keeping the past DB growth in calculation how we predict future growth.
Any help greatly appreciated. Thanks.