web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Extreme database usage...
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Extreme database usage on Rollupjobbase

(5) ShareShare
ReportReport
Posted on by Carretje 11
We have an problem in our production Database of Dynamics. The RollupJobBase table takes over the 30 gig.
 
 
We have only 107 Rollupfields and a lot of are defeault fields. 
We do not see this behavior in our Sandbox environment. 
We already cleaned the asyncoperations (That where successful, cancelled, and failed) but that didn't have any effect. And i Can't find any information on how to debug this.
 
Is there something else we can quick or clean up? Because this is a big issue.
 
Categories:
Dynamics 365 general
I have the same question (0)
  • DynDan365 Profile Picture
    DynDan365 5 on at
    we do have the same problem, we only have have 6 rollup fields, we bulk delete all successful async-operation records daily, but still the database is growing daily on all our environments, so DEV, Staging and PROD:
     
    the growth is truly significant from January 9th 2025 with only 0.38 GB to 47GB on February 2nd 2025.
     
    I hope MS can just "clean up" the database with a simple script on their server side.
  • DynDan365 Profile Picture
    DynDan365 5 on at
    @Carretje: I deleted all audit logs from the Test environment and the rollupbase table has shrink since then (you can see two days of reduction):
     
     
     
    7GB reduction in just two days. 
     
    On my other environments where I did not delete audit logs, the growth is still happening in the same crazy way, so here is PROD:
     
     
    (4 GB of growth in the last two days.)
     
    so SOMEHOW deleting audit logs and the reduction of RollUpJobBase table seems to be related.
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 91

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 72 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 69

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans