Storage is over capacity – Freeing storage for Common Data Service Microsoft Dynamics 365

New cloud storage model doesn’t reduce or don’t have any bad impact on the system but it gives a proper chance of analysing deep i.e details on top files tables and Growth Rate E.T.C

Navigate: https://admin.powerplatform.microsoft.com/analytics/capacityhttps://www.youtube.com/watch?v=UvFrGg8-FP8

1st thing we checked our environment which are not Production and straight forward we knew QA, DEV, TEST FILES and LOGS data can be deleted that will free up around 200GB of data.

So Storage Capacity Usage is Divided into 3 Parts

• File and database: The following entities store data in file and database storage:
  • Attachment
  • AnnotationBase
  • Any custom or out-of-the-box entity that has fields of datatype file or image (full size)
  • Any entity that is used by one or more installed Insights applications and ends in – Analytics
• Log: The following entities are used:
  • AuditBase
  • PlugInTraceLogBase
• Database only: All other entities are counted for your database

Use the following methods to free up storage for each of the capacity types.

File	Method 3: Remove email attachments using Advanced Find
	Method 4: Remove email messages with attachments using a bulk deletion job
	Method 5: Remove notes with attachments using Advanced Find
	Method 6: Remove notes with attachments using a bulk deletion job
Log	Method 10: Delete audit logs
	Delete plug-in trace logs using a bulk deletion job
Database	Method 1: Delete bulk email and workflow environments using a bulk deletion job
	Method 2: Evaluate and delete suspended workflows
	Method 7: Remove bulk duplicate detection jobs and associated copies of duplicate records
	Method 8: Delete bulk import environments using a bulk deletion job
	Method 9: Delete bulk deletion job environments using a bulk deletion job

New cloud storage model doesn’t reduce or don’t have any bad impact on the system but it gives a proper chance of analysing deep i.e details on top files tables and Growth Rate E.T.C

• Actual database usage
• Top database tables and their growth over time
• Actual file usage
• Top files tables and their growth over time
• Actual log usage
• Top tables and their growth over time

To view environment-level capacity analytics

1. Select Analytics > Capacity > Storage capacity.
2. Select an environment.
3. Select Details ().

We will now have visibility (via the report in the Power Platform admin centre) into precisely what is using up their data – file storage, log storage, or database storage.

So Above it says Almost 73GB of storage is occupied by Attachment an I have opened QA. so I can free up to 73GB just by deleting attachment after confirming from the customer.

-> Same way we can run bulk delete on QA, dev of Attachment, emails, notes

-> Then Audit is also a big chunk of data sitting on QA and DEV we don’t want.

So this detail chart section is quite helpful

1. Select Analytics > Capacity > Storage capacity.
2. Select an environment.
3. Select Details ().

References:

https://docs.microsoft.com/en-us/power-platform/admin/capacity-storage

https://docs.microsoft.com/en-us/power-platform/admin/whats-new-storage