web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / DB Storage
Service | Customer Service, Contact Center, Fie...
Suggested answer

DB Storage

(0) ShareShare
ReportReport
Posted on by TedW 479

Hi,

We are in the process of trying to reduce our DB capacity as its currently showing as only 13% left.

I have asked Microsoft to analyse the activitypointerbase table as this is taking up the vast majority of space.

As expected, emails are taking up the vast majority of space, but IncidentResolution and OpportunityClose are taking up a sizeable amount of space too.

I know what IncidentResolutuon and OpportunityClose records are, but has anyone had any experience in bulk deleting these particular records? And if so, what are the consequences of deleting them? how will that affect Case and Opportunity records?

Thanks a lot

I have the same question (0)
  • Suggested answer
    Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: DB Storage

    Hi Ted,

    The storage for entities can be estimated as similar to that for SQL Server for any entities and fields that you add, with the addition of ~150 bytes per record for system fields (createdby, modifiedon) etc.

    If you want to do the calculations in detail, assume that decimal types have scale = 38, and date time is stored as the SQL datetime datatype. Also, currency fields and rollup fields have additional system fields auto created (though they show up in the UI).

    In overall use, one of the things that can have a big effect on storage is Activities. If a lot are created, then this can add up. For each activity there are significantly more system fields than other entity types; I'd reckon on 1KB overhead per activity record.

    Here is an example that you can also follow: 

    1. Table A with probably 16 custom columns and 8279 records is 11.84 MB

    2. Table B with probably 36 custom columns and 6792 records is 8.84 MB

    3. Account Table with 7482 records is 13.79 MB

    Refer to the below links:

    Solved: CDS Entity Sizing/Data Usage - Power Platform Community (microsoft.com)

    Solved: Dataverse Database capacity and file capacity size - Power Platform Community (microsoft.com)

    Best Regards,

    Sayen Zhang

  • TedW Profile Picture
    TedW 479 on at
    RE: DB Storage

    Hi Sayen,

    Thanks for your reply, good to know. Do you know how much space a single Case Resolution or Opportunity Close record takes up? I'm guessing they are very small so deleting thousands of them probably wont make that much difference to our Storage.

    Thanks again

    Ted

  • Suggested answer
    Sayen Zhang Profile Picture
    Sayen Zhang on at
    RE: DB Storage

    Hi partner,

    Case Resolution (IncidentResolution) entity contains special type of activity that includes description of the resolution, billing status, and the duration of the case.

    Opportunity Close entity is created automatically when an opportunity is closed, containing information such as the description of the closing and actual revenue.

    We can create a bulk delete job to delete them. Here is a reference link: Free up storage space - Power Platform | Microsoft Learn

    This will not affect Case and Opportunity records unless you want to stay Case Resolution and Opportunity Close entity.

    Best Regaeds,

    Sayen Zhang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 100 Super User 2025 Season 2

#2
Suresh Kulla Profile Picture

Suresh Kulla 72 Super User 2025 Season 2

#3
DAnny3211 Profile Picture

DAnny3211 54

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans