Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Database size in MB WebResourceBase

  • 1.  Database size in MB WebResourceBase

    SILVER CONTRIBUTOR
    Posted Nov 04, 2019 10:30 AM
    Is there a good way to monitor and purge the WebResourceBase it sits for us at about 1 gig and it would be nice to recover this storage if the data is not needed.

    -Ryan

    ------------------------------
    Ryan Green
    Landscape Structures
    Delano MN
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Database size in MB WebResourceBase

    TOP CONTRIBUTOR
    Posted Nov 05, 2019 01:23 PM
    Ours is around the same size.  You could go into Settings > Customization > Customize the System, then Web Resources, and then look through the list to delete any custom web resources that were added by you/your team/your partner.  You could also uninstall old managed solutions you no longer use.  Other than that, I'm not sure if there is a way to reduce that table.  I'm interested to hear if others have tips for it though.

    ------------------------------
    Ben Edgren
    CRM Applications Manager
    Hufcor, Inc
    Janesville WI
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Database size in MB WebResourceBase

    Posted 23 days ago
    Running into capacity issues and the Web Resource base is a major culprit.  I don't want to start deleting these in the SBX without knowing what is being used and what's not.  You know how to run statistics on Web Resource usage?

    ------------------------------
    Jeff Orris
    Jeffrey Steven Orris - Independent Consultant
    Harrisburg
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Database size in MB WebResourceBase

    SILVER CONTRIBUTOR
    Posted 23 days ago
    I recommend talking to MS Support. Our Web Resource table was also growing each month. Support was able to run some cleanup jobs on the backend that improved the storage significantly. They also said they were looking at a more universal solution of some kind as this table is a common problem for most customers.
    Here's a quote from MS Support on 8/3/2020: "The Web Resource Table growth became a common issue to our customers and we are actively working on a generic solution for this which may take some weeks but no specific time for this and there is no update to share you for now. Once this is available the same will be shared to the customers."
    I've not yet heard anything further about this.

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Appleton WI
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Database size in MB WebResourceBase

    MICROSOFT MVP
    Posted 22 days ago
    There is actually a brand new tool in the XrmToolBox​ that investigates sizes of individual webresources and by solution.
    Does not help purge, but can give you some good hard facts for your communication with MS.
    Link from here: https://twitter.com/rappen/status/1311227448432963589

    ------------------------------
    Jonas Rapp
    MVP
    Sweden
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Database size in MB WebResourceBase

    SILVER CONTRIBUTOR
    Posted 22 days ago
    Thanks for the tip @Jonas Rapp! I like the new tool.
    Any thoughts on using the XRMToolbox tool: "Webresources Manager" by Mscrm Tools in conjunction with the new tool? It seems like with these 2 tools combined, you can do just about anything with WebResources.
    The Mscrm tool provides a search for dependencies and says it can delete web resources too.
    I'm hesitant to trust the dependency search, and even more hesitant to delete web resources that aren't from my own solutions.
    However, WebResources takes up about 25% of my CRM storage--and I've already removed all the solutions I could!
    Any suggestions/thoughts?​​

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Appleton WI
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: Database size in MB WebResourceBase

    MICROSOFT MVP
    Posted 22 days ago
    Hi Greg
    Web Resource Manager is good when you are working with your own web resources in DEV, but you can't (shouldn't!) really use it to purge MS files.
    I would say we just have to live with their perhaps bloating of our DBs. but having good metrics is essential when confronting MS about "We pay for storage, your own solutions consume silly amounts of that storage - let us pay for what WE add!"
    Jonas

    ------------------------------
    Jonas Rapp
    MVP
    Sweden
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 8.  RE: Database size in MB WebResourceBase

    SILVER CONTRIBUTOR
    Posted 21 days ago
    I figured that was probably the situation. Any chance we could get a button in the new tool for exporting the list--perhaps to .csv or .xlsx? It'd be nice to see that list in Excel.

    ------------------------------
    Greg Enns
    ERP Coordinator
    Technical Prospects
    Appleton WI
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role