Question
Infosys
AU
Last activity: 25 Oct 2019 8:04 EDT
PEGA0005 Alert on pr_data_decision_df_met table
PEGA0005 alert on UPDATE pr_data_decision_df_met "PC0" SET "PXMETRICS" = ? WHERE ( "PC0"."PXWORKID" = ? AND "PC0"."PXNODE" = ? ) is continuosly coming in the Alerts .
We disabled the DSS setting - prconfig/initservices/vbd/default -> false .
But still getting the alert in alert logs .
Any recommendation on how to fix that .
Pegasystems Inc.
FR
Hello,
Is it very high above the threshold? Can you involve your DBA in order to have an execution plan explanation maybe.
Pegasystems Inc.
IN
Hi ,
Ideally PEGA0005 alert is triggered when the elapsed time for a query to the PegaRULES database exceeds the operation time threshold setting.
as default threshould for pega0005 alert is 500 ms , so you need to verify the the mentioned table with respect to all the queries which are taking more time for the execution.
Disabling this DSS setting - prconfig/initservices/vbd/default -> false . we don't think it will help here
If its taking more time than threshold then you need to work with your DBA for the execution plan of queries or it might need creation of indexes on the tables.
Thanks
Pegasystems Inc.
US
There are several points I would like to point out here:
1. First, please check the distribution of these alerts, if most of the alerts KPI fall under certain value (e.g., 1 sec), you may consider increase the threshold to 1 sec to eliminate majority of the alerts.
2. Do work with DBA to make sure all these update queries are tuned and normal from DBA's perspective.
3. When using PDC, I see this query in the improvement plan for all my internal environments (which do not have much load at all), so this might not be problem at all, it is used for updating dataflow metrics. In fact, PDC actually gives us an distribution like here - which will guide you what threshold is set to eliminate most of the alerts (assuming you already confirmed with DBA and consider this is 'normal').
