Hi,
We are facing an issue with the 100 % CPU utilization in BPM DB schema for the BPM based application.
DB team confirmed that, more number of operations are being performed on PRTPROCLOCK table, hence the shareplex took more time to sync the data between primary DB and secondary DB.
We observed that, more number of records are being processed since 4 days in production. Hence more number of records are getting inserted into DB.
I would like to understand more on the table PRTPROCLOCK, i didn’t get any info in docs. Please let me know if you have any idea on this table.
As there are more number of records are being processed in production, we can ask support team to upgrades the servers with memory. Would it be really helpful?
Do we need to increase the CPU and memory of DB servers or we need to increase for MWS servers as well. As of now no issue with the MWS server. But, after the DB CPU utilization, JVM in MWS servers is responding slowly and memory is also filled up.
Also we don’t have any scheduler to purge the data in WMERROR and WMSERVICE table, i am going to suggest support team to remove the old data in these tables. Are there any other tables that we can purge which should not impact the BPM process.
As per our scheduler we are purging the data only for processArchive, service Archive, serverArchive, documentArchive.
Please confirm if these services archives the data being stored in both IS core audit and process audit tables or do we need to configure any other schedulers.
Thanks,
Varun