Skip to main content
Dynamics 365 general forum
Suggested answer

Timeout issues and storage issues

editSubscribe (0) ShareShare
ReportReport
Posted on by 180

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 issues, any advice would be great

  • Suggested answer
    PerezAguiar Profile Picture
    PerezAguiar on at
    RE: Timeout issues and storage issues

    Hey!
    The first thing to analyze would be to check the storage of all instances you have. This analysis should tell how much storage of each type you're using on each environment.  For example, you can start by removing unnecesary log partitions from Sandboxes.  If the log storage is too high on Production instances, you should consider asking your business stakeholders if you can remove older data:  data that has been created more than 1 year ago, for example. Please remember this should consider if there's any business/legal requirement to keep certain time (for example, some business must keep 2 years of data).

    pastedimage1615796363878v2.png

    The second thing to analyze would be each specific table on each environment:

    pastedimage1615796384688v3.png

    Depending on the affected table, you can take some actions, based on https://docs.microsoft.com/en-us/power-platform/admin/free-storage-space

    I hope this helps,

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans