HP 3PAR System Reporter Software - Manual (Page 171)

7.3 Configuring Sampling Policies
System Reporter 2.8 3PAR System Reporter User’s Guide
7.2.1 Compacting Databases
When some sampling policies are changed or when the number or sizes of systems being
sampled is reduced the size of the database may be reduced significantly.
If a MySQL or Oracle database is being used and there is a significant change in size, the
database’s tables do not automatically shrink. A compaction must be performed on the
database in order to recover the file space. To start a compaction on the database, change the
policy labelled Perform compaction of the database after next sample to now,
daily or to the specific day of the week depending on whether you want to perform the
compaction now, immediately after each daily sample or immediately after the daily sample on
the specified day of the week.
Number of days to keep Adaptive
Optimization hourly samples
7
Number of days to keep daily samples 366
Ratio of Hi-Res performance samples to
Hi-Res space samples.
Typically space changes are slower than
performance so space sampling can be configured
at a slower rate than performance sampling.
6
Perform compaction of the database after
next sample (SQLite only. Sampling will be
stopped and database will be unavailable for
several minutes)
see Compacting Databases on page 7.3
daily
If there is a problem with sampling, send
email to this address.
Email is only sent if the sampling problem requires
the sampler service/daemon to exit.
(blank)
Table 7-1. Sampling Policies
Policy Default