Pega application slowness
SummaryUsers 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 MessagesPega0005 alert messages indicating sppr_sys_reservequeueitem_b is taking a lot of time.
Steps to ReproduceNot reproducible on demand.
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.
ResolutionApply the SQL changes associated with HFix-28777.
Published August 4, 2016 - Updated August 12, 2016