Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Dynamics 365 general forum / Database space consume...
Dynamics 365 general forum

Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

(1) ShareShare
ReportReport
Posted on by MattFJohnson 195

I know this has been asked a couple of times before but there is never really a definitive answer. We've got some permanent demo orgs set up in our O365 tenant. As you can imagine, they have minimal records in (either the sample data set or just a few records we've added to be able to show functionality). I've also gone through all the usual space saving exercises like deleting audit logs and old system jobs using recurring bulk deletes but they're still 5GB+ each. 

The thing is, what is taking up all the space is actually tables which it would seem D365 requires to run. WebResourceBase (1.5GB), SystemFormBase (1GB), RuntimeDependancyBase (400MB), RibbonClientMetadaBase (390MB). 

There doesn't seem to be a way to find out what is taking up all the web resource space. If it was a certain managed solution maybe we could evaluate whether it was necessary to keep or not. 

Why are these tables coming out of our storage allowance if we can't do anything about how big they are? Why are they so massive? 1GB+ for some system forms? nearly 400MB for some ribbon metadata? It seems bit harsh that we must pay for this stuff as storage. 

Has anyone got anywhere raising this as a support case and getting Microsoft to dig into the back end and find out?

Categories:
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    I can confirm this has happened on 2 of my tenants. Nice of them to tell us!. Haha

    One of them with 15 environments in went from 80GB to 40GB in the database table over night. You can see how important this was. 

  • Suggested answer
    Asutosh Profile Picture
    Asutosh 5 on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    Hi All,

    Microsoft has finally Migrated 'WebResourceBase' and 'RibbonClientMetadataBase' tables to File Store. As Database Capacity is required to have free storage for creating new Environment and performing Backup and Restore operations, this would greatly help to reduce the storage consumption in Database Capacity.

    Additionally, there won't be Index Storage Usage for large files in Files Store which will also help with table storage reduction.

    I think that this move will help to address all the storage concerns which we have regarding storage used by OOB Metadata. As the default capacity provided for File Capacity is 20 GB which is more than Database Capacity. Plus the cost for File Capacity addon is also considerably less than that of Database Capacity.

    Thanks,

    Asutosh

  • Suggested answer
    Cleiton Santos - KFF Profile Picture
    Cleiton Santos - KFF 95 on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    Hi all,

    I've put a ticket with Microsoft and they replied saying that is a known issue and they are working on a solution; in the meantime, they are increasing my client storage temporarily until they resolve the issue.

    I would suggest you do the same and use the Capacity reports to show them that the storage is pretty much consumed by their internal web resources and data. If you don't know where to find the Capacity reports they are on admin.powerplatform.microsoft.com/, go to Resouces -> Capacity -> Storage Capacity and click the little arrow icon beside the environment. There you can download the database capacity usage by entity and verify that the consumption is all on their internal entities such as WebResourceBase, RibbonClientMetadataBase, and so on, on my case pretty much all the storage was consumed by Microsoft stuff.

    Cheers,

    Cleiton

  • Cleiton Santos - KFF Profile Picture
    Cleiton Santos - KFF 95 on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    Hey guys, any luck with this?

    I'm implementing D365 for a customer and they only have the fresh vanilla Prod with DEV and UAT with some customization (minimum data), so they cannot even go live because they are already overcapacity. Not fair MSFT charging all the clients storage for their own stuff

  • MattFJohnson Profile Picture
    MattFJohnson 195 on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    Yes I think you're right. This is probably why MSFT upped the "free" space you get from 5GB to 10GB by default because they realised their app alone takes up nearly 5GB of the initial space granted and that's before any users start hammering it with data. 

    I personally think these areas of the database should not be included against your storage allowance. It wouldn't be hard for them to classify it differently just as they have with logs and attachments. It is fundamental to the functionality of D365 so hardly seems fair the the customer has to pay for it as part of their storage with the price they're paying as it is. 

  • Suggested answer
    Matt Collins-Jones Profile Picture
    Matt Collins-Jones 230 User Group Leader on at
    RE: Database space consumed by D365. What's it all for? Web Resources, System Forms etc.

    Hi Matt

    I believe this is default storage which is required for the application. Moving Dynamics onto the consumption model allows you to spin up as many environments you need as long as you have a minimum of 1GB of storage available, so this appears to be the default required for the application.

    I'm not sure there's much more you can strip out of the system from the sounds of it.

    thanks

    Matt

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans