Skip to main content
Contact a Moderator

Question

1
Replies
145
Views
 Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 226 posts
Anthem
Posted: January 31, 2018
Last activity: January 31, 2018
Posted: 31 Jan 2018 9:43 EST
Last activity: 31 Jan 2018 16:10 EST
Closed

SELECT TOP - Long Running Queries - review and recommendations.

Hi Team,

We could find a lot of "SELECT TOP " Long Running Queries in our environments.

PFA for the queries.Please help.

System Administration Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 31 Jan 2018 16:10 EST
Ankur Das (@nkur.das_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

Hi,


SQL queries in the attached xlsx are related to Rule ABA Cache population. In other words, the ABA cache was being primed for the first time after you did an application deployment or upgrade. Once the cache is primed you should not be seeing these PEGA0005 Alerts for the same queries. 


The magnitude/impact of the queries in terms of time taken to execute is not considerably high than the OOTB threshold of 500ms. However, if you would like to improve the query execution times, it is recommended to update the statistics explicitly of the following tables on a periodic basis.

 

pr_sys_app_hierarchy_flat

pr_sys_app_ruleset_index

pr4_rule_vw

pr_sys_appcache_dep

pr_sys_class_ancestors

 

SQL:- UPDATE STATISTICS <schema>.<table_name> WITH FULL SCAN

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice