‎04-01-2024 10:47 PM
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
Solved! Go to Solution.
‎04-03-2024 09:25 AM
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/
‎04-03-2024 09:25 AM
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/
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now