Versión 7.9.17
Sugar Versión 6.5.25 (Compilación 344)
Hello, lately I am having problems with the performance of my CRM, in certain occasions it freezes and it takes to respond again.
I would like to know if there is any way that I can detect the source of this problem, if this is how I could increase the performance of my CRM.
There are many different things that could be happening here. You might have a failing disk or network card, for example.
Meanwhile, if you run the first query in this post:
https://pgorod.github.io/Database-tables-size/
You can get a sense if you have a problem with overgrown tables. If your problem is not hardware, I believe this query will point you to the problematic point.
Many users face the same situation of freezing the CRM and response time. There is a certain way to overcome these problems some are states here and definitely, it will help you to increase the performance of your CRM
https://store.outrightcrm.com/blog/improve-suitecrm-performance/