Question

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.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
December 26, 2017 - 9:37pm

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.

Comments

Keep up to date on this post and subscribe to comments

December 18, 2017 - 8:12am

Please update the PRPC version as well.

 

December 18, 2017 - 9:13am
Response to Rachit_Agarwal

Sure.

PRPC 718

DB : SQL Server.

December 18, 2017 - 9:15am

Hi,

Can you please attach alert log, what is the time these queries are taking ?

December 18, 2017 - 9:24am
Response to SudhakarReddy

PFA for the ALERT log (PLA).

 

December 20, 2017 - 11:32pm
Response to PradeepChowdaryP

Hi Team,

Any update please.

December 26, 2017 - 2:32pm

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.

December 26, 2017 - 3:20pm

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

December 26, 2017 - 9:37pm

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.