Extreme database usage on Rollupjobbase

(5) Share

Report

Posted on by Carretje

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)

All responses (2)

Answers (0)

DynDan365 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
DynDan365 5 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No