Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Extreme database usage on Rollupjobbase

Like (3) ShareShare
ReportReport
Posted on 30 Jan 2025 07:48:06 by 7
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:
  • DynDan365 Profile Picture
    DynDan365 5 on 05 Feb 2025 at 10:07:37
    Extreme database usage on Rollupjobbase
    @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.
     
     
  • DynDan365 Profile Picture
    DynDan365 5 on 03 Feb 2025 at 09:54:38
    Extreme database usage on Rollupjobbase
    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.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete