Re: Database growing too fast !!!
2000-03-15 11:22:50
Subject: |
Re: Database growing too fast !!! |
From: |
Richard Sims <rbs AT BU DOT EDU> |
Date: |
Wed, 15 Mar 2000 11:22:50 -0500 |
Joyce - Here are some thoughts on controlling database content.
Richard Sims, BU
Database consumption factors - All the administrative definitions are
here; elminate what is no longer
needed.
- The Activity Log is contained in the
database: control amount retained via
'Set ACTlogretention N_Days'.
- The database is at the mercy of client
nodes or their filespaces being
abandoned, and client file systems
and disks being renamed such that
obsolete filespaces consume space.
- Volume history entries consume some
space: eliminate what's obsolete via
'DELete VOLHistory'.
- More than anything, the number of
files cataloged in the database
consume the most space, and your
Copy Group retention rules govern the
amount kept.
- Make sure that clients are not running
Selective backups (i.e., full backups)
routinely instead of Incremental
backups, as that will rapidly inflate
the database. Likewise, be very
careful of coding MODE=ABSolute in
your Copy Group definitions.
- Talk to client administrators about
excluding useless files from backup,
like temp directories and web browser
cache files.
- Make sure that 'EXPIre Inventory' is
being run regularly.
- The size of the Aggregate in
Small Files Aggregation is also a
factor: the more small files in an
aggregate, the lower the overhead in
database cataloging. See: Aggregate.
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Database growing too fast !!!, Joyce Woods
- Re: Database growing too fast !!!, John Naylor
- Re: Database growing too fast !!!, Doug Thorneycroft
- Re: Database growing too fast !!!, Bates, Richard
- Re: Database growing too fast !!!, Jason Morgan - I.T.
- Re: Database growing too fast !!!, Gary Ison
- Re: Database growing too fast !!!,
Richard Sims <=
- Re: Database growing too fast !!!, Kauffman, Tom
- Re: Database growing too fast !!!, Doug Newman
- Re: Database growing too fast !!!, Richard Cowen
- Re: Database growing too fast !!!, Cook, Dwight E
- Re: Database growing too fast !!!, ANGEL BUGARIN
- Re: Database growing too fast !!!, Richard Sims
- Re: Database growing too fast !!!, Cook, Dwight E
- Re: Database growing too fast !!!, Peter Svendsen
- Database growing too fast !!!, Joyce Woods
- Database growing too fast !!!, Joyce Woods [mailto:Joyce.Woods
|
|
|