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 :
Customer experience | Sales, Customer Insights,...
Answered

AsyncOperation table in sandbox environment is unusually large

(0) ShareShare
ReportReport
Posted on by 32

Hi all,

I copied our production environment to sandbox about a month ago and the AsyncOperation table in the sandbox is now unusually large. I've run through all the suggested system job bulk deletions but it is still massive - 28GB compared to under 6GB in production. Does anyone know if there is any more I can do to bring this down?

Thanks

pastedimage1681988071231v1.png

I have the same question (1)
  • Suggested answer
    PerezAguiar Profile Picture
    Microsoft Employee on at

    Hey Richard.

    The first thing is that this is File capacity, not DB Capacity.  There's a nice explanation on how to connect to the DB and understand why are those jobs there (in File Capacity) and checking since when.  YOu can read it on    .

    Can you confirm that the Sandbox environment is running normally (i.e., doesn't have the "Admin mode" enabled? )  Also, by connecting to the DB and understanding what type of jobs are the ones being put on File Storage, you can understand better why this is not reducing.

    Regards,

  • richard001 Profile Picture
    32 on at

    Thanks for the tip, I'll take a look at this.

    Also, I can confirm the sandbox is not in admin mode.

    Richard

  • richard001 Profile Picture
    32 on at

    I think I got to the bottom of this. Thank you!

  • kamay2 Profile Picture
    2 on at
    Can you share what you found? I'm running into the same problem. Thanks!

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 129 Super User 2026 Season 1

#2
Jimmy Passeti Profile Picture

Jimmy Passeti 46 Most Valuable Professional

#3
NeerajPawar Profile Picture

NeerajPawar 41

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans