AsyncOperationBase table consuming too much space Dynamics 365 Online

(0) Share

Report

Posted on by MdNazar

Hi,

I am using Dynamics CRM 365 Online version. I have requested microsoft for the top 10 tables consuming too much storage and found that AsyncOperationBase, WorkflowLogBase tables have consumed close to 6GB space. Please let me know what are the steps tp delete data from these tables so that i can save some space and performance speed.

Thanks

Najm

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Community Member on at

Like (0)

Report

Hello,

you could ask MS to run this script for the AsyncOperationBase: support.microsoft.com/.../performance-is-slow-if-the-asyncoperationbase-table-becomes-too-large

here some posts about your issue: community.dynamics.com/.../75043

community.dynamics.com/.../229560

Was this reply helpful? Yes No
MdNazar on at

Like (0)

Report

Can't we do it instead of Microsoft running the script. I mean we don't have access to the DB but can a workflow/job be written to clear those tables

Thanks

Was this reply helpful? Yes No
Verified answer

joman 617 on at

Like (0)

Report

CRM-Parameters-(System)-Data management-Bulk Delete.

There you can create Deletion workflow (Repeatable, if you want).

Was this reply helpful? Yes No
Verified answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi MdNazar,

You can create the Bulk Delete Job for all the completed system jobs and schedule this bulk delete job to run daily.

us.hitachi-solutions.com/.../using-the-bulk-delete-feature-in-crm-2011

community.dynamics.com/.../tip-346-scheduling-daily-bulk-delete-jobs

Hope this helps.

Was this reply helpful? Yes No
MdNazar on at

Like (0)

Report

Thanks for your reply. What about the WorkflowLogBase table. How to delete those records ?

Was this reply helpful? Yes No
bhupendra 167 on at

Like (0)

Report

Does this helps in improving performance?

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi Bupendra,

Yes, cleaning data from these tables does help if they are consuming more space. You should first check what all entities are consuming size and then go for deletion.

Hope this helps.

Was this reply helpful? Yes No