Skip to main content

Hello,

I have a test tenant that has grown to 41GB. Does anyone have any experience with optimizing a tenant size. 

I have already deleted all old snapshots. The majority of the data are in the Note and UploadFileRevision tables.

 

Hi @AndrewBGL 

Can you delete the tables which are not needed and decrease the size?

Did get a chance to review this 

 


The only option I know of is to create a customization project and use a script to delete the notes:

Delete Note where GraphType='KNCFCore.KNCFLogMaint'

 


Hi @AndrewBGL 

Can you delete the tables which are not needed and decrease the size?

I do not have experience with deleting tables and wanted to see what options I have. 

 


Hi @AndrewBGL 

Can you delete the tables which are not needed and decrease the size?

I do not have experience with deleting tables and wanted to see what options I have. 

 

https://community.acumatica.com/maintenance%2Dand%2Dtroubleshooting%2D229/how%2Dto%2Dreduce%2Dthe%2Ddatabase%2Dsize%2Dby%2Dremoving%2Dold%2Dfile%2Drevisions%2D4007?tid=4007


Hello @AndrewBGL 

Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3 

 


@manikantad18 I am reading the post now.

 


Hello @AndrewBGL 

Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3 

 

Thanks for sharing the help article.


Since the Note is the largest table is there a way to optimize it?


The Note table will most likely require a SQL script. Recommend testing it first  

delete top (10000) f
    from  Note f
    where CompanyID = 2 


What about using a share drive for attachments (Uploaded Files )….. instead of saving to the Database ?

 


Hello @AndrewBGL 

Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3 

 

Checked the article. How would I check the notes table?


What about using a share drive for attachments (Uploaded Files )….. instead of saving to the Database ?

 

Yes that is a good idea. For large attachments like photos or videos we use our server to upload.


Hello @AndrewBGL 

Sharing this help article which goes over Cleanup of database https://help-2023r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=fb069b91-154b-4745-8991-300d5c8a6ae3 

 

Checked the article. How would I check the notes table?

I used the Search In Files to find the files that are in the upload. I do not see a way to sort or filter by files size. Is there a way to find what files are the largest?

 


FYI, I was finally able to fix this issue by adding a database script to delete the data from the notes. Here is a screen shot of the script. 

 


In total about 35 GB of data was removed and the test tenant is no 6.6 GB in size. 

Thanks for all the responses. 


Reply