Question
Anthem
US
Last activity: 3 Jan 2018 0:43 EST
Long running queries causing system slowness.Recommendations/Solutions please.
Hi Team,
Could you please help resolve the long running queries causing system slowness.
PFA for the same.
Pegasystems Inc.
US
Please update the PRPC version as well.
Anthem
US
Sure.
PRPC 718
DB : SQL Server.
JPMorgan Chase & Company
US
Hi,
Can you please attach alert log, what is the time these queries are taking ?
Anthem
US
PFA for the ALERT log (PLA).
Anthem
US
Hi Team,
Any update please.
Pegasystems Inc.
US
Please post the actual PegaRULES-Alert log if you want specific help. In general you should look at the alerts to see where the time is being spent. You would then want to have DBA run explain plan on the query and add appropriate indexes to speed up the query performance.
Pegasystems Inc.
IN
From the excel sheet shared you can look for PEGA0005 alerts and from there filter the KPIOVERTHRESHOLD for the max values .
From the long tab find the long running queries ,submit to DBA then as said by Celeste your DBA will run the explain plan and from there take it further .
Thanks,
Arun
Accepted Solution
Swedbank AB
SE
Hi,
We have also faced similar long running queries on cache tables. Attached queries also contains the OOTB cache tables in delete queries.
pr_sys_appcache_shortcut
pr_sys_appcache_dep
pr_sys_app_hierarchy_flat
pr_sys_class_ancestors
GCS team suggested to truncate the cache tables and reset the DB stastics. It worked for us.
Thanks,
Deva.