Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Timeout issues and storage

  • 1.  Timeout issues and storage

    Posted Mar 12, 2021 06:49 AM

    We have been having a number of timeout issues since upgrading to the Dynamics 365 CE UUI interface. 

    My MS Gold partner has advised the below. 

    • Work with yourself on reducing the database size where possible
    • Optimise our queries to cater for performance degradation

    My database size is:

    Database usage File usage Log usage
    48.85 4.11 14.53

    I have gone through the database and entities and removed any unnecessary files especially from the ActivityPointerBase as this is what seems to be using the most storage. Any ideas on what else i can do to save storage?
    I use audit history quite alot when investigating issues and you cannot choose what to delete in audit table so not sure what to do here. We also only went live with CRM in 2018 so not that old

    However i have a bulk load of contacts to import in. So I am not sure what needs doing here as i will be increasing the database size. 

    Has anyone come across these kinds of problems and and advice on what to do would be great. 



    ------------------------------
    Ravi Mistry
    Countryside Alliance
    London
    ------------------------------


  • 2.  RE: Timeout issues and storage

    TOP CONTRIBUTOR
    Posted Mar 12, 2021 08:35 AM
    Ravi, are you on-prem or online? The answer will be different depending on that.

    With on-prem, you will have a lot of control over trying to optimize. In regards to database size, for each entity you will be able to see how much space the table is taking and how much the indexes use. You will also be able to optimize indexes yourself. On server side, you can set the app pool to recycle at certain intervals and adjust other settings as needed.

    With online, it's really Microsoft engineers' job to optimize and maintain your instance. You can't optimize indexes yourself, but you can request an optimization. When you download all table sizes in the Dataverse area on the admin center, you are seeing the total of table plus indexes for each entity. You don't even get row counts anymore.

    A support case may be a good place to start, but be prepared to have a lot of patience and provide as much detail as possible so that the technicians can help. They have access to more information than you do and they may possibly be able to adjust things in the tenant that will make a difference beyond simple database size management.

    If AsyncOperationBase is one of your large tables, you should look at how your workflows are setup. For example, are they set to delete on completion if successful? Also, there may not be much usefulness in keeping things in AsyncOperationBase for more than a few days. In addition to workflow settings you could have a scheduled bulk delete to remove records for System Job entity with completed date older than X and no recurrence date.


    "The opinions expressed are strictly my own and not necessarily those of my employer, Minitab LLC"



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



  • 3.  RE: Timeout issues and storage

    Posted Mar 12, 2021 09:32 AM
    Hi Andy,

    I am online.

    I have looked in the Dataverse area.
    Can Microsoft support do optimization for me? Or does that job fall down to my MS Gold partner?

    I have already an open case with MS. They just advised to look in Dataverse and delete data which is taking up the most space. In my case this is Activity Pointer Base.
    They told me to look at this link.
    https://community.dynamics.com/365/f/dynamics-365-general-forum/402451/customer-guide-how-to-reduce-activitypointerbase

    I have already removed as much as i can from the activity pointer table. See my counts below.


    Activity Name Number of Records
    Letter 991716
    Activity 398418
    Email 128977
    Phone Call 36893



    ------------------------------
    Ravi Mistry
    Countryside Alliance
    London
    ------------------------------



  • 4.  RE: Timeout issues and storage

    TOP CONTRIBUTOR
    Posted Mar 15, 2021 08:12 AM
    Ravi,

    For index optimization, that will need to be done by Microsoft support. They will likely tell you that it happens on a regular, automated basis. If you can point them to specific entities and operations with those entities, they may be able to do something beyond what the scheduled processes do. The partner may be able to help in other ways such as looking at workflows or plugins that may be contributing to the timeouts.

    When do you see timeouts, is it when getting row counts, running advanced find queries, plugins?

    Years ago we had an issue with the async engine not keeping up with jobs, and they moved us to a different tenant and it solved the problem. There also could be a problem with a "noisy neighbor" which is another organization in your tenant heavily using resources. That's something only the Microsoft engineers can identify.

    "The opinions expressed are strictly my own and not necessarily those of my employer, Minitab LLC"

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



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