License report really slow

[toomasy]

Hi

We have about 10000 items in lansweeper and we are using dedicated sql server (not express) for lansweeper, but license report takes about 10min to load (Select Licenses tab -> Click License report button). In license report there is 73 items.

Is there anything I can do to make license report query quicker?

[toomasy]

Thank you, that KB article helped. 🙂

[Daniel_B · Accepted solution]

In order to solve performance issues we generally recommend following the steps in this KB article. This will clear old event logs and shrink the database. It should also have an influence on the license compliance report.

If this doesn't solve the issue, could you write a mail to support@lansweeper.com and we will follow up via mail. Could you attach screenshots of the Configuration\Database scripts page, section Database Table Size, so we can have a look at your database size.