Garbage Collector times out in large Snow Inventory environments
In large Snow Inventory environments, the Garbage Collector may run slowly or time out. The Snow Inventory database may continue to grow even when few or no new inventory sources are added.
This issue has been observed in environments with more than 50,000 endpoints and applies to Snow License Manager 25.x.x or later and Snow Inventory 25.x.x or later.
The Snow Inventory Server log may contain errors similar to:
2026-03-18T10:41:18+01:00;garbage-collection;;;;Consider increasing the value of the SqlCommandTimeout property in configuration. [System.Data.SqlClient.SqlException]: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The Garbage Collector first runs a query to determine what data should be removed. As the database grows, or if the Garbage Collector has not run for a period of time, identifying the data to remove can take longer and may exceed the configured SQL command timeout.
Another possible error is:
2026-04-22T17:04:03+03:00;garbage-collection;;;;DataApplication table cleanup failed, current chunk remains unprocessed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This message means that the Garbage Collector could not complete the current cleanup chunk for the inv.DataApplication table before the SQL command timed out. Similar timeout messages may occur for other tables, such as inv.DataSoftware.
The wording current chunk remains unprocessed indicates that the failed chunk was not removed and must be processed again during a later Garbage Collector run.
If SqlCommandTimeOut is too short, timeout errors may become more frequent as the database continues to grow.
Upgrade Snow Inventory Server
Performance improvements have been made to the Snow Inventory Server Garbage Collector. If the environment is running an older version, consider upgrading to take advantage of these improvements.
Adjust the Garbage Collector timeout
Garbage Collector settings are configured in snowserver.config.
The file is usually located at:
C:\Program Files\Snow Software\Snow Inventory\Server
The location may differ if a command-line argument has been added to the Snow Inventory service definition.
Configure the Garbage Collector module with a longer SqlCommandTimeOut, for example:
<ModuleConfiguration>
<Module typeName="GarbageCollectionModule">
<Setter propertyName="SqlCommandTimeOut">1800</Setter>
</Module>
</ModuleConfiguration>
If the issue persists, increase the SqlCommandTimeOut value further as needed.
Review retained metering history
Review the configured DaysOfCumulativeTableHistoryToKeep value to determine how much historical metering data is being retained.
If appropriate for the environment, reduce the retention period and align it with the METERING_HISTORY_MONTHS setting in Snow Management and Configuration Center (SMACC), or configure a lower value if there is no requirement for immediate recovery of older metering data.
For additional guidance, see Best Practices for Large Environments.