Disk filling up when running Housekeeper

Started by Darren Leggett, February 07, 2025, 12:00:46 PM

Previous topic - Next topic

Darren Leggett

Running NetXMS 5.1.3 on a Windows 2022 server and MS-SQL 2019
Every time the housekeeper runs, the disk begins filling up at an alarming rate (several GB/min) until it is full.
The problem seems to be that the transaction log for the netxms_db database is growing to fill the disk.
If disk space is increased the log will just grow to fill it next time 
the housekeeper runs.
Has anyone else had this problem and if so how did you fix it?

Filipp Sudanov

There's a setting DBWriter.HouseKeeperInterlock in Configuration->Server Configuration. You may try setting this to "Yes" - in this case there will be no data writes while housekeeper is running.
DCI data will be kept in database writer queue, consuming system memory. You may want to set DBWriter.MaxQueueSize to some value to limit possible memory consumption.