Scanning Queue Stuck, not processing

[GoHawks5]

We've seen this issue for the last 3-4 weeks and have not been able to find a resolution.

We're an enterprise of just under 10k assets, we are using an IP scan of all subnets on our network. This has been working until recently when the devices stopped processing out of the scanning queue and the scanning queue continues to build up.

We're able to get 6-12 devices to scan through after restarting the Lansweeper Service, but then the queue goes back to stalling and building up.

We've added a second scanning server and have found that to perform the same way.

Currently I've disabled all scheduled scans and are trying to process scans manually, but see the same issues?

This has been submitted to support 2 days again, heard nothing back, hoping community may have ideas for us to try.

[Mister_Nobody]

We decided to restart LS process every day because it eats more 6 GB memory during scanning (old version use about <1 GB). So virtual memory is over and queue stucks.

[Schhim]

I am dealing with the same issue at the moment. I notice this started happening after updating Lansweeper to 10.4.3.1. Were you able to resolve your issue? 

[ErikT]

@Mister_Nobody ,  

Performance scanning targets may be clogging up and slowing down the scanning queue. These run in the background and are not visible on the scanning queue.

To attempt to resolve the issue, please follow the steps below: 

• Clear the scanning queue by restarting the concerned scanning service under services.msc on the device hosting the scanning server.
• When the queue has cleared, rerun the scanning targets. 

Should the issue persist, disable all scanning under Scanning\Performance Scanning. (if any are enabled) and repeat the above steps. 

If disabling your performance scanning resolves the issue, we recommend following the steps below to prevent the issue in the future:

• Configure your performance scanning targets to scan fewer assets or less frequently to reduce the resources used here.
• Increase your Windows scanning threads under Configuration\Server Options.
• Add additional scanning servers to your installation and spread your scanning targets across multiple machines. https://www.lansweeper.com/knowledgebase/setting-up-an-installation-with-multiple-scanning-servers/

[Mister_Nobody]

No, we don't use Performance Scanning.

[GoHawks5]

UPDATE: We set the Event Viewer Logs to 7 days, then ran the DB clean up job and it dropped our DB size significantly and scans are working again.

[GoHawks5]

Another thing is the Import feature using Lspush.. devices sit in there as well w/out syncing.

[grimstar]

Is the new database set for autogrowth? If you go to Configuration->Database Tables, does it actually say you have some unallocated space? How large is your database?

Using my own server for perspective I see it is 27551MB, 1191MB unallocated, ~11k devices (14k assets).

[GoHawks5]

I'll check w/ our DB guys..

Assets: 13569
Size: 12413.63 MB
Unallocated: 56.83 MB

[Mister_Nobody]

LS Server Microsoft SQL Server 2017 on Windows Server 2019
Schema Version: 700
Assets: 16699
Size: 11415.06 MB
Unallocated: 387.89 MB

Also we added 2 scheduled tasks:
1. Clean_tblServicesUni:
DELETE FROM tblServicesUni WHERE ServiceuniqueID NOT IN (SELECT serviceuniqueid FROM tblservices)

2. Delete_Future_Events:
delete from tblntlog where tblNtlog.TimeGenerated > Current_TimeStamp