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.
Database Optimization: Space Usage
Userlevel 7
+12
Hi
Can you delete the tables which are not needed and decrease the size?
Did get a chance to review this
Userlevel 6
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'
Userlevel 6
Hi
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.
Userlevel 7
+12
Hi
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.
Hello
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
Userlevel 6
Userlevel 6
Hello
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.
Userlevel 6
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
Userlevel 2
What about using a share drive for attachments (Uploaded Files )….. instead of saving to the Database ?
Userlevel 6
Hello
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?
Userlevel 6
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.
Userlevel 6
Hello
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?
Userlevel 6
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.
Userlevel 6
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.