Question
1
Replies
138
Views
Anthem
Posted: January 31, 2018
Last activity: January 31, 2018
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.
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