Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Database Storage
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Database Storage

(0) ShareShare
ReportReport
Posted on by TedW 460

Hi,

This is a general question, but does anyone have any information on how much database space a Model Driven App generally uses? I need to clear up space urgently. We have a number of apps in our Dev and Sandbox sites that we rarely use and only for testing purposes. I have gone through the MS article about clearing up DB space already and that hasn't made any noticeable difference. I also contacted Microsoft who ran some scripts to free up space in the webresource table.

The cost of purchasing extra DB capacity is extortionate!

Thanks as always,

Ted

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database Storage

    Hey, these two orgs have almost nothing in them and are 'model driven apps' with their own Databases, so it can give you an idea.  If its a shared DB then itll drop significantly.

    pastedimage1609441327589v1.png

  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Database Storage

    Hey Ted.

    There's this nice post from a Support Engineer from Microsoft on how to reduce ActivityPointerBase: community.dynamics.com/.../customer-guide-how-to-reduce-activitypointerbase

    Also, if you already have a support case open with Microsoft, you should have communications or an action plan on how to proceed to reduce this.

  • TedW Profile Picture
    TedW 460 on at
    RE: Database Storage

    Thanks Henry. The Activitypointerbase table seems to be taking up over 5GB. I have asked Microsoft and waiting on a response.

    Ted

  • Suggested answer
    Henry J. Profile Picture
    Henry J. 5,237 on at
    RE: Database Storage

    Hello Ted,

    I don't think believe model-driven apps consume much space, as all they do is reference existing components (entities, forms views, charts, etc.)
    You can identify the tables that consume the most storage in the Power Platform Admin Center:
    https://docs.microsoft.com/en-us/power-platform/admin/capacity-storage#environment-capacity-analytics 

    Henry

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans