Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / What is going on with ...
Sales forum
Suggested answer

What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

Posted on by 195

We have an almost blank D365 Sales org we use for demos. It has steadily grown in size over the last 12 months. Now that we are allocated a certain amount of database space, rather than paying by the environment, this is becoming more of an issue.

When you create a new D365 Sales app deployment, it sits at about 1GB. Sometimes, things happen that make the space jump massively. For instance on 2nd Feb this year the ribbonClientMetatdataBase table almost doubled overnight for no apparent reason from 600MB to 1+GB. The webResourceBase table is over 2GB!

pastedimage1581073166754v1.png

If you go over you limit you now must pay £30 per GB per month for this database storage. These are Microsoft controlled tables which the app relies on to function. There is nothing we can do about their size and they just seem to grow and grow and grow. I think these tables should be excluded from our database allowances. We are paying on a per user per month basis for the app anyway which should cover these essential tables. It is very unfair to make us pay twice. Either that or we need to be given tools to allow us to reduce the size of these talbes. I mean really, what could possible be stored about ribbon meta data that takes up more than 1GB in a database? It's crazy!

I have these problems in about 5 different environments in the same tenant. Basically blank D365 apps which take up over 5GB each and they didn't start out that way. They have just grown over time with nothing we can do about it. I have tried all the usual steps of cleaning them up by running bulk delete jobs etc. 

pastedimage1581073466957v2.png

Categories:
  • Suggested answer
    TLDR Profile Picture
    TLDR 5 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    Hi,

    it seems like Microsoft moved webresources from database pool to files pool within Dataverse. It is a little trick providing them more time to solve it for real. Anyway it immediately "solves" the capacity and thus license problems on database.

    Let's see when Microsoft presents the results of webresources "hassle": www.linkedin.com/.../dyckyusti_microsoft-dataverse-webresources-activity-6746734658475622400-aT5b

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    I think the point is, that it shouldn't be at 2.5GB+ in the first place. Maybe if you got them to run it on yours, it would go down below 2GB?

  • Abbas Khan Profile Picture
    Abbas Khan 255 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    In my case, it went up one day (with MS auto updates I guess) as I had not made any changes to this environment.

    I published all customisations (default solution) and next day it was back to where it was.

    pastedimage1605518968983v1.png

    Not sure if it is to do with publishing default solution or something else ran in the background!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    I have been working with Microsoft on this recently and have found out some interesting information. If you submit a support case there are a couple of things they can do to help.

    1) They can reduce the size of WebResourceBase by running a script to get rid of orphaned resourced. For me, this removed anywhere between 700MB-1GB from the table. This is very significant as I have 15 environments.

    2) They can run a script so that deleting Import Jobs actually removes the files from the database. This means that ImportJobBase table goes from about 700MB down to 20MB. To do this, after they've run the script just run a Bulk Delete on the Import Jobs entity.

    3) They are now looking into the RibbonClientMetaDataBase table to see what they can do. I don't know how far they will be but this is another one of those tables that is nearly 1GB and for what? I am going to push ahead with the other top tables taking up space after this one.

    With these tables being used for such different things, microsoft support have to go to different teams to reduce them so it takes a long time and requires separate cases.

    I strongly suggest everyone goes and logs tickets for this to reduce the size of tables. Why should we be paying for this space?! It is shocking we have to pay for space to store system tables anyway but if the data is not even being used by the system but they are just too lazy to clean it up, this is even more shocking.

    The Microsoft guy I was talking to said they are soon going to store WebResourceBase under the File allocation instead of database allocation. This is a step in the right direction but still not totally acceptable in my opinion. I think this will come in Apr '21 Wave 1.

    I still think that Microsoft should not be charging us for space we use if there is no way we can reduce that space and me and others are fighting for changes to be made.  

  • Abbas Khan Profile Picture
    Abbas Khan 255 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    Hi Matt, did you ever find out issue behind it and solution?

  • MattFJohnson Profile Picture
    MattFJohnson 195 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    Hi Thomas, Did you mean to title your post "We should pay for system tables in our storage"?

    Surely you meant "We should NOT pay for system tables in our storage"

  • thomasjs Profile Picture
    thomasjs User Group Leader on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    experience.dynamics.com/.../

  • MattFJohnson Profile Picture
    MattFJohnson 195 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    As I suspected, even THEY can't do anything about it. This is why I think it's doubly unfair that we should bear the cost of this spiralling data size. The article they link to pretty much just says reduce the amount of columns in your quick find views and remove multi line fields. I find this table particularly egregious as it's seemingly badly names. how could ribbon metadata take up over 1GB unless it's just being stored in the most inefficient way possible. Also, webresources taking up so much space when individual solutions are in the low MB's so it can't be actual webresources. It must be something else stored in there.  

    Here is the response form the case:

    I have reviewed the case details and understand that you would like to reduce the size of the RibbonClientMetadatabase table.

    RibbonClientMetadataBase: Consists of a collection of parameters and metadata information about ribbons. It also contains information about dependencies, runtime elements between entities. It is a system generated table and we don't have control over it.

    There are few implementations made to include new features to the online organizations which has resulted in spike in storage of this table.

    This has been reported by other customers on whose organizations the deployment has happened.

    Please consult the following documentation to know more about the improvements:

    docs.microsoft.com/.../capacity-storage

    Please feel free to reach out for any further assistance with regard to this support request.

  • MattFJohnson Profile Picture
    MattFJohnson 195 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    I've asked support (via a case) about this issue previously and just been told it is all required for the system to run. The point of this post is really to highlight the issue and get a bit of community support around petitioning Microsoft to do something about it. Also to spread awareness of this issue too. I think it is very unfair that microsoft charge us for these tables to be stored in the most expensive way £30+ per month per GB. Maybe even just categorising it to the File Usage data type would be acceptable.

    Just to cover all bases I have created a support ticket today to see if there is anything that can be done which hasn't already been tried or might be new.

    Case Number: 120031924002879

  • Suggested answer
    Paul_Owen Profile Picture
    Paul_Owen 2,027 on at
    RE: What is going on with the size of this database? webResourceBase ribbonClientMetatdataBase

    The web resource table is because of the new PCF controls I believe of which there are a lot, however they shouldn't be part of your storage IMO. As for the ribbonmetadata, if you create a support case MSFT should be able to help with reindexing that.

    Regards

    Paul

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans