Garbage collection

GarbageCollectionModule

This section describes how to configure the Garbage Collection. Garbage collection is used for removal of historical inventory data from the Inventory database.

propertyName

Description

IsEnabled

Set to true , garbage collection will run.

Set to false , no garbage collection will run.

Default = true

Note

  • It is recommended not to disable this feature because the database accumulates an unmanageable quantity of data, which uses up a lot of hard-drive space and slows down the processing speed.

  • If the feature is disabled by chance for a long time, it is recommended to change the configuration setting SqlCommandTimeOut either to a higher value or zero to complete the job. This may take days based on the quantity of the accumulated data. After the job is done, set the configuration to a reasonable value.

Interval

Specifies the time that must pass since the prior run of the garbage collector has completed. This value is specified in the hh:mm:ss format.

Default = 02:00:00

SqlCommandTimeOut

Set the time limit of duration (in seconds) for how long garbage collection will run for each individual query to the database. When set to 0 , the duration has no limit (infinite duration).

Default = 180

DaysOfCumulativeTableHistoryToKeep

Set the number of days to keep historical data of user login, metering, metering concurrency, and cloud metering.

Default = 90

DaysOfMetricHistoryToKeep

Set the number of days to keep statistical troubleshooting data.

Default = 30

Note

This data can only be read by Snow Software staff.

DaysToKeepAssignedIdsWithoutData

Set the number of days that the garbage collector will keep the entries for the devices that tried to reach Snow Inventory but never reported a full inventory scan, before being removed.

Example 31.
<ModuleConfiguration>
    <Module typeName="GarbageCollectionModule">
      <Setter propertyName="IsEnabled">true</Setter>
      <Setter propertyName="Interval">"02:00:00"</Setter>
      <Setter propertyName="DaysOfCumulativeTableHistoryToKeep">90</Setter>
      <Setter propertyName="DaysOfMetricHistoryToKeep">30</Setter>
      <Setter propertyName="DaysToKeepAssignedIdsWithoutData">7</Setter>
      <Setter propertyName="SqlCommandTimeOut">180</Setter>
    </Module>
</ModuleConfiguration>