Skip to main content

Notifications

Announcements

No record found.

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 474

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

  • 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 474 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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,233 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans