US - Texas - Houston - CRM

Expand all | Collapse all

CRM Database Storage Capacity Issue

  • 1.  CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted 6 days ago
    Hi,

    I'm having issues with our database capacity and it's always over rapidly. I have requested our vendors to increase the capacity to 150GB but looks like there is a cap with Microsoft on this they have to set up a whole new one for us.


    I want to check and see if any of you have best practices or ways I can free up some of this space.
    I have tried everything in this article and it is of not much help. - https://docs.microsoft.com/en-us/power-platform/admin/free-storage-space#reduce-database-storage

    Please advise.

    ------------------------------
    Regards,
    Geethika L
    ------------------------------


  • 2.  RE: CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted 6 days ago
    Some additional info.



    ------------------------------
    Regards,
    Geethika L
    ------------------------------



  • 3.  RE: CRM Database Storage Capacity Issue

    TOP CONTRIBUTOR
    Posted 6 days ago
    A couple things:

    1. It looks like you have a custom ISV that is taking up a lot of storage.  I would reach out directly to them and see what is safe to delete or at least not reside in your Dynamics database. I don't recognize the cdi_ prefix offhand.
    2. You appear to have a massive amount of activities.  Activities are almost never directly useful once they're completed, so maybe either purge activities over a year old, or move them to a SQL Azure database for historical reporting.

    ------------------------------
    Wayne Walton
    Senior Solutions Architect
    Hitachi Solutions America, Ltd.
    Atlanta GA
    ------------------------------



  • 4.  RE: CRM Database Storage Capacity Issue

    GOLD CONTRIBUTOR
    Posted 6 days ago
    For us it's emails with large attachments that take up a lot of space. I periodically run this advanced find and delete everything that I find.


    ------------------------------
    Mark Suchman
    CRM Lead
    Ascend Performance Materials
    TX CO
    ------------------------------



  • 5.  RE: CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted 5 days ago
    You also have the ability to set up SharePoint as the storage location for the attachments that can be accessed through the D365 email.

    ------------------------------
    Hugh Konigsmark
    Global CRM/CPQ Director
    Bray International, Inc.
    Houston TX
    ------------------------------



  • 6.  RE: CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted yesterday
    Yes, I currently store all attachments in Azure.

    ------------------------------
    Regards,
    Geethika L
    ------------------------------



  • 7.  RE: CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted yesterday
    I use attachment management app to have them stored in Azure, so that isn't the issue for me. It's all the click dimensions data like someone below mentioned.

    Thank you.

    ------------------------------
    Regards,
    Geethika L
    ------------------------------



  • 8.  RE: CRM Database Storage Capacity Issue

    GOLD CONTRIBUTOR
    Posted 5 days ago
    The cdi_ prefix is ClickDimensions.

    ------------------------------
    Andy Arndt
    Minitab, Inc.
    State College PA
    ------------------------------



  • 9.  RE: CRM Database Storage Capacity Issue

    GOLD CONTRIBUTOR
    Posted 5 days ago
    I would say older ClickDimensions PageViews and Visits could be bulk deleted. That should free up a lot of space in your org.

    ------------------------------
    Andy Arndt
    Minitab, Inc.
    State College PA
    ------------------------------



  • 10.  RE: CRM Database Storage Capacity Issue

    TOP CONTRIBUTOR
    Posted 2 days ago
    I agree with Andy - if you have anonymous visitor tracking set up, it's taking up TONS of space. I have a bulk delete for lots of random clickdimensions data that is useless after 6 months or so. Anonymous pagveviews, IPs, etc. that aren't associated with a lead yet.

    ------------------------------
    Brooke Browne
    Marketing Director
    Smartbridge
    Houston TX
    ------------------------------



  • 11.  RE: CRM Database Storage Capacity Issue

    SILVER CONTRIBUTOR
    Posted yesterday
    Clearing these helped! Thank you!!

    ------------------------------
    Regards,
    Geethika L
    ------------------------------



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