Support Article

Pega application slowness



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.


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.