Windows or Linux?

If Windows, consider moving to Linux. Windows is not an ideal operating system if you have many users & labs.

Check Tomcat memory allocation

• Open the 'setenv.sh' file lies in the '<tomcat directory>/bin' directory, and check below lines are present in the file or not.

  export JAVA_OPTS="-Dfile.encoding=UTF-8 -Xms128m -Xmx2048m -XX:PermSize=64m -XX:MaxPermSize=512m"
  export CATALINA_OPTS="$CATALINA_OPTS -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=<path to dump file>"

Check DB memory allocation

Please refer to MySQL prerequisites page.

Check CPU and memory utilization.

• Open Task Manager (Windows) or top command (Linux).
• Check if any process entirely consumes CPU or memory. If some process is hogging all the resources, identify the process, and check what is going on with it.
• Repeat this on both app and DB server.

Check database transactions

• Login into the database.
• Run the following command for MySQL: 

show full processlist;

• It will display current running transactions in the database.
• Check if any of the processes are long-running or hogging all the DB resources.
• If yes, identify the query and check if it was run by OpenSpecimen application.