Performance problems

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:

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