>rule of thumb for sizing the database is that it should be between 1%
>and 5% of the total amount of space required for data storage.  We've
>got about 10,000,000 files that ADSM is tracking with about 800 GB in
>the storage pools (plus copy storage pools for everything) and our
>database is about 8 GB.

The size of an ADSM database does not depend on the amount of
storage pool space required, but rather on the number of files
stored.  The rule of thumb mentioned above is therefore very crude, at
best.  If you have an idea concerning the number of files to be stored,
following is a much better predictor of database size.

Every version of a file requires approximately 500-600 bytes of database
space.  Each additional copy of the file (i.e., cached copy or copy
in a copy storage pool), requires an additional 150-200 bytes of database
Additional database space will be required to allow for partially filled
pages and other overhead.

Dave Cannon
ADSM Development