Team,
We are using alfresco enterprise 7.3 version with GCP hosted MS-SQL database [SQL Server 2019 Enterprise] with 40 core / 256GB RAM with 6 ACS host in clusters and 2 solr hosts in GCP environment.
Since document coming from SAP in high volume, we see alfresco tomcat sometime freezed, that resulted into hanged application (application not responding at all and tomcat frozen, only restart is option that time.) we see DB CPU utilization didn't even go beyond 50%, but after restart it resume operations, since nodes are in clusters, it is affecting other hosts as well, and we need to restart those things.
Is there any issue with MS-SQL and Alfresco connections? I faced similar thing in past alfresco version around 4.x as well, My-SQL and Postgres works fine with alfresco.
Is there any tuning parameters to "Alfresco" configuration or "MS-SQL" let me know.
Even checking logs doesn't help with Root Cause.
Please advice.
