You can increase the storage limit for historical performance data. This enables

Performance reports to display a greater amount of historical data.

The storage limit for historical performance data is set by default to a conservative

value of 5 million database rows. You can increase this value; however, this can

lead to a degradation in the performance of the Performance reports.

To increase the storage limit for historical performance data:

1. Locate the following file:

v UNIX $NCHOME/etc/precision/NcPollerSchema.cfg

v Windows %NCHOME%etcprecisionNcPollerSchema.cfg

2. Find the section that contains the following lines:

-- =========================================================================

-- pruning

-- =========================================================================

create table config.pruning

(

MAXPOLLDATAROWS long64 not null

);

--

-- This defines the maximum number of rows allowed in ncpolldata.polldata.

-- Once the number of rows exceeds this limit the older data will be pruned

-- until close to the limit again.

--

-- Increasing this number will result in an increase in the data storage

-- size required for historical data and may also lead to a degradation

-- in the performance of reports using this data.

--

insert into config.pruning (MAXPOLLDATAROWS) values (5000000);

3. Change the value of MAXPOLLDATAROWS..