Lansweeperdb table size

[mike1013]

I am curious to what is consider large table size that should be truncated. We are using sql express 

For example 

Table,                          Size in MB,                       Size used in MB

tbPNPsigneddrivers       143.75                          used 129.52
tblchangetracking          56.95                            used 45.80
tblCertificatelocations    40.49                           used 32.34
tblAssets                         31.05                           used 20.39
tblsoftware                     21.77                           used 18.56
TBLprintdrivers               18.88                           used 15.03
tblcertificatekeyusages  16.13                           used 5.56

[Obi_1_Cinobi · Accepted solution]

Hello there!

If you are facing any performance issues, we recommend performing a manual cleanup using the instructions provided here: https://community.lansweeper.com/t5/troubleshooting-your/clearing-tables-to-free-up-space-and-improv...

Moreover, to manage the database size effectively, we suggest that you review our automated cleanup options documented here: https://community.lansweeper.com/t5/lansweeper-maintenance/perform-automated-database-cleanups/ta-p/...

In case you need further assistance, please get in touch with our tech support team by visiting https://www.lansweeper.com/contact/contact-support/