Reported Issues: Processes are going to queued state and not moving into a Running state.
The database was not in a good condition.
Simple query execution directly in SQL Server Manager is very slow from SQL client.
Investigation showed this to be at least in part due to not having enough disk space in C drive and CPU utilization is near or above around ~90 all the time.
1. Cleaned queued records and aborted records within Process Automation, had the DBA review and tune the database.
2. Instead of using common DB for both Lib and Runtime, we separated the Runtime DB using the installer.
Plan to use PAM Cluster to improve overall throughput and provide for some redundancy and failover capability.
Add more disk space and CPU cores to DB server.