Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Performance degrades with multiple long running AA queries

SA-84496

Summary



Development system's performance degrades and multiple long running AA queries are generated in the Alert log. The Development environment is running the MS SQL server.


Error Messages



AA query sample:

SELECT TOP 1 r.pxinsid AS "pzRuleName" 
FROM   pega73rules.pr_sys_appcache_dep d 
       JOIN pega73rules.pr4_rule_vw r 
         ON ( d.pzimplementationkey = 'html_section.ra_stream_assetinformation_ae22ace27415a3f6f7d1df9150e55bbc' 
              AND d.pzcacheconfigid = '762781845' 
              AND d.pzexplicitexcludecombined IN ( 0, 2 ) 
              AND d.pzappliestoclassname = '+NA' 
              AND d.pzdepruleinsid = r.pxinsid 
              AND d.pzruletype = r.pyclass ) 
       JOIN pega73rules.pr_sys_app_hierarchy_flat h 
         ON ( h.pztopapphash = 'DLLCOrig!en_US__shared!DLLCOrig:DLLFlowManager!02.07$fbf549c02124ca24eda6e98ad01593d3' ) 
       JOIN pega73rules.pr_sys_app_ruleset_index a 
         ON ( a.pzapphash = h.pzapphash 
              AND r.pyruleset = a.pzrulesetname ) 
WHERE  ( a.pzrulesetversionmajor = -1 
          OR ( a.pzrulesetversionmajor = r.pzrulesetversionmajor 
               AND ( a.pzrulesetversionminor = -1



Steps to Reproduce



Unknown.


Root Cause



The MS SQL server cannot handle AA queries with Complex Join.


Resolution



Perform the following local-change:

Disable AA query with <env name="fua/enableAssemblyAvoidance" value="false" /> prconfig.
Suggest Edit

Published October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us