Question
3
Replies
81
Views
Posted: June 13, 2020
Last activity: June 16, 2020
PEGA0005 Alerts in Production
There is PEGA0005 alert in production for a report definition ,which is simple select query with 3 where clause.All the columns are exposed and indexing also done in the table .still its generating alert .what would be the next step to check.
***Edited by Moderator: Pallavi to update platform capability tags***
Hi,
Can you please check the value of below DSS or in Prconfig.xml file and let us know.
alerts/database/operationTimeThreshold
If it has default value 500, try increasing it accordingly and check logs.
Also, try to check with your DBA to execute EXPLAIN command for your query to check its performance.
Thanks,
Bala