System Reporter 2.8

3PAR System Reporter User’s Guide

Table 7-1.Sampling Policies

 

Policy

Default

 

 

Number of days to keep Adaptive

7

Optimization hourly samples

 

 

 

Number of days to keep daily samples

366

 

 

Ratio of Hi-Res performance samples to

6

Hi-Res space samples.

 

Typically space changes are slower than

 

performance so space sampling can be configured

 

at a slower rate than performance sampling.

 

 

 

Perform compaction of the database after

daily

next sample (SQLite only. Sampling will be

 

stopped and database will be unavailable for

 

several minutes)

 

see Compacting Databases on page 7.3

 

 

 

If there is a problem with sampling, send

(blank)

email to this address.

 

Email is only sent if the sampling problem requires

 

the sampler service/daemon to exit.

 

 

 

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.

Configuring Sampling Policies

7.3