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 / Dynamics 365 general forum / Table sizes - what'...
Dynamics 365 general forum

Table sizes - what's typical, what they're used for, and how to reduce?

(0) ShareShare
ReportReport
Posted on by Community Member

We're running out of storage space for our Dynamics 365 instance, so I'm trying to get the table sizes under control.

I used the new Admin center to view the top tables by size. The top 10 are:

  • Attachment - 1,617 MB
  • WebResourceBase - 1,206 MB
  • RuntimeDependencyBase - 1,196 MB
  • AsyncOperationBase - 984 MB
  • AnnotationBase - 770 MB
  • ActivityPointerBase - 720 MB
  • RibbonClientMetadataBase - 481 MB
  • SystemFormBase - 385 MB
  • PluginAssemblyBase - 295 MB
  • 10565 - 265 MB

I plan to use Attachment Management to move the attachments into Azure blob storage to get that table under control.

For the other 9 tables, are those sizes typical? What is stored in those tables? What if anything can be done to reduce their sizes?

I already setup recurring bulk delete system jobs for:

  • System Events with status completed; status reason of failed, succeeded, or canceled; and older than 4 months
  • Workflows with status completed; status reason of failed, succeeded, or canceled; and older than 1 month
  • Bulk Duplicate Detection with status completed; status reason of failed, succeeded, or canceled; and older than 1 month
  • Bulk Delete with status completed; status reason of failed, succeeded, or canceled; and older than 2 months
  • Traces older than 1 month

Audit logs total only about 3 MB.

Any help, suggestions, and/or information is greatly appreciated!

Thank you!

Categories:
  • Priyesh Profile Picture
    Priyesh 7,396 User Group Leader on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Thank you Matt,

    If you find my answer useful. Kindly mark as verified.

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Hi Matt,

    In addition to figuring out yourself, you can also contact Microsoft Support to assist you on this. I am sure they have sql scripts which they can run against your environment to clean up AsyncOperationBase.

  • Community Member Profile Picture
    Community Member on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Thanks for mentioning CalculateRollUpFields. I added a job for that. I already had ones for Workflows and System events.

    Audit logs are negligible and we don't have sandbox environments, but it is a good idea.

    Thanks.

  • Suggested answer
    Priyesh Profile Picture
    Priyesh 7,396 User Group Leader on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    I advise to start a weekly job that deletes the Completed/Failed/Suspended System Jobs of types Workflows/CalculateRollUpFields and System events running every weekend or fortnight.

    That will keep unnecessary data from filling up your space.

    Next, check your Audit Logs as well. Delete the ones that you don't need.

    I also advise to look at other organizations in the tenant. They too might be consuming space even though they may be Sandbox environments.

  • Community Member Profile Picture
    Community Member on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Is there any way to see how much storage space each managed solution is using?

    Some managed solutions, like Field Service and Project Service Automation have multiple patches listed in solutions. Is it safe to delete the older patches? For example, Project Service Automation has ProjectService_Patch_1, ProjectService_Patch_2, ... ProjectService_Patch_6, ProjectService_Patch_7, and ProjectService_Patch_8. Is it safe to delete patches 1 - 7, leaving just 8, which is the most recent?

    I already went through and checked the "Automatically delete completed workflow jobs" checkbox for any workflows where it wasn't already checked, but thanks for the suggestion.

    Matt

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Hi,

    I think you have already done what you could do reduce your storage. But if you still want to do more, you can review all your web resources and check if you are really using it or these just the old/unsused web resources. You can do the same for system form base & plugin base.

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    If you have installed managed solutions then also web resource and run time dependency table size will increase.. also CRM has some default customization which contains web resource and dependency.

    For AsyncOperation base table you can minimize size. On the workflows there is one checkbox "Automatically delete completed workflow jobs" you need to check this checkbox for any new or custom workflows.. also you can check is there any completed workflows, you need to delete those.

    also check these articles

    support.microsoft.com/.../performance-is-slow-if-the-asyncoperationbase-table-becomes-too-large

    community.dynamics.com/.../260488

  • Community Member Profile Picture
    Community Member on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    Thanks for that information!

    For WebResourceBase, RuntimeDependencyBase, and AsyncOperationBase are our sizes typical for a small company with minimal customization?

    WebResourceBase - 1,206 MB

    RuntimeDependencyBase - 1,196 MB

    AsyncOperationBase - 984 MB

    Is there anything that can be done to reduce the size of those tables, or are we stuck with 3.5 GB being used by default system stuff?

    Thanks again.

  • Verified answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Table sizes - what's typical, what they're used for, and how to reduce?

    hi

    Attachment -  All the attachments attached to notes will be stored in this table.  

    WebResourceBase - All web resources - html, images, java script,  style will be stored in this table.

    RuntimeDependencyBase - web resoruce, form, field dependencies

    AsyncOperationBase - All workflow jobs

    AnnotationBase - notes

    ActivityPointerBase - email to, cc, bcc fields etc.

    RibbonClientMetadataBase - ribbon customization

    SystemFormBase - Entity forms

    PluginAssemblyBase - Plugin assemblies

    hope this will help..

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,238 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