How do you know that this alert is coming because of database query.Please verify alert logs,The above alert looks like pega0001 alert which means html is taking time to load.Are you getting any other alert along with this alert.If it is related to database then there will be pega0005 alert.Try to find out a pattern of alerts like pega0005 followed by pega0001.Check the query in pega0005 and create index if it is not present.
Please let me know If you have any query.
Posted: 2 years ago
Posted: 24 Oct 2019 8:20 EDT
Rimjhim Srivastava (srivr1)
Senior Technical Solutions Engineer
As from this message "interaction has exceeded the elapsed time alert threshold of 1000 ms: 1595 ms." it shows PEGA0001 alert is generating , So you need to check the logs and verify which all Activities in your application is generating the pega0001 alert , based on that you can determine in which area you need to fine tune this issue as its not indicating the DB issue.