Garbage collection


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




Set to true , garbage collection will run.

Set to false , no garbage collection will run.

Default = true


  • 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.


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


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


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

Default = 90


Set the number of days to keep statistical troubleshooting data.

Default = 30


This data can only be read by Snow Software staff.


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.
    <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>