Support Article

Pega application slowness

SA-26446

Summary



Users using the application are facing slowness issue.  The JVMs appear normal, however Database analysis by the DBA suggests that there are queries that are running more slowly than usual.


Error Messages



Pega0005 alert messages indicating sppr_sys_reservequeueitem_b is taking a lot of time.


Steps to Reproduce



Not reproducible on demand.


Root Cause

The query sppr_sys_reservequeueitem_b is poorly optimized in this version of Pega.

​It sorts in an inefficient manner, which causes queue tables such as the SLA queue and work indexing queue to operate more slowly.


Resolution



Apply the SQL changes associated with HFix-28777.
 

Published August 4, 2016 - Updated August 12, 2016

Have a question? Get answers now.

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