Unanswered

Dataverse - Cleaning up Storage

(0) Share

Report

Posted on by angelatrolio

Hi,

I work at an organisation and currently looking into cleaning up their storage, as we are approaching capacity limit. I was wondering if there is any clear way to find out what tables are using the most storage, power apps or power automate. We are not using dataverse for CRM purposes but moreso, Power Platform and data management.

Thanks,

Angela.

Categories:

Governance & administering

I have the same question (0)

All responses (5)

Answers (0)

velegandla 204 Moderator on at

Like (0)

Report

@angelatrolio
You need to start at environment level to find the usage of database size, file size and log size.
https://admin.powerplatform.microsoft.com/resources/capacity#environments

Once you know the environment then look at the tables in each environment which got most number of records and then plan to archive/delete.

make sure to do the analysis then depends on usage you might need to communicate with your business, change management which include rollback options and then actual implementation of the change.

====================================================
https://www.linkedin.com/in/devendravelegandla/

Was this reply helpful? Yes No
angelatrolio 26 on at

Like (0)

Report

Thank you. Is there any automated ways to check all the tables or does it need to be done manually and assess how many records are in each table?

Was this reply helpful? Yes No
velegandla 204 Moderator on at

Like (1)

Report

@angelatrolio
Click on details icon for each environment from capacity https://admin.powerplatform.microsoft.com/resources/capacity#environments, you can download the list of tables with size.

====================================================
If this response helped you in any way, please give kudos by clicking the 'Thumbs Up'/'Like' button and/or marking it as an 'Accepted Solution'. This helps others by providing a quick way to identify likely solutions to their issues.

https://www.linkedin.com/in/devendravelegandla/

Was this reply helpful? Yes No
angelatrolio 26 on at

Like (0)

Report

Excellent, thank you so much. Do you know if: msdyn_AIBFileAttachedDataBase is related to the AI Builder. Is there any way to reduce this table?

Was this reply helpful? Yes No
velegandla 204 Moderator on at

Like (1)

Report

@angelatrolio
That is correct. Please see the documentation from MSDN.
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/msdyn_aibfileattacheddata?view=dataverse-latest

You might need to look at the number of solutions built using AI Builder. This would help in what causing the table size then decide on what needs to be done.
For AI Builder report, you need to download it from capacity section to evaluate what was created by whom.

====================================================
If this response helped you in any way, please give kudos by clicking the 'Thumbs Up'/'Like' button and/or marking it as an 'Accepted Solution'. This helps others by providing a quick way to identify likely solutions to their issues.

https://www.linkedin.com/in/devendravelegandla/

Was this reply helpful? Yes No