Foglight chart chunking of data older than ~30 minutes (4319056)

Under Manage Data Retention Polciies"

1. Click the CartName_Agent_Table
2. Clear the checkbox “Copy Inherited Retention Policy
3. Enter your desired Age & Rollup values and metric duration
4. Click the green +
5. Add your 2^nd generation roll-up value or purge.

An example would be:

Age       Rollup Period
1 min         1 min
3 days      1 hr
14 days    4 hrs
1 month     purge

The initial age of 1 min will cause the server to persist the data sooner. The ages of 3 days and 14 days are there to match the default settings in the storage configuration. These can be changed (e.g. 1 day and 3 days as in the original configuration), but the server will actually use values that match the storage configuration, so it's probably better to keep it configured this way to avoid the discrepancy.

There shouldn't be much memory overhead with this change because values will be persisted just as quickly. There will be more values inserted into the database, but if this is just for a couple of collections then that probably won't make much difference. There will also have to be more values loaded from the database, but since there are still rollups configured the granular data will be limited to at most 3 days which shouldn't be too bad.

NOTE:  Any entries made in Data Retention only affect NEW collections, not the previously collected data.

Also see SOL48246 “Set purge policy for Type_1 Script agent” and “About Data Retention Mechanisms”