→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mike1013
Engaged Sweeper II

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

 

 

1 ACCEPTED SOLUTION
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

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/

View solution in original post

1 REPLY 1
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

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/