Question

2
Replies
200
Views
Close popover
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 206 posts
Anthem
Posted: December 28, 2017
Last activity: December 29, 2017
Closed

Recommendations to resolve SP sppr_purge_table related long running queries.

Hi Team,

Could you please help fixing the below mentioned System Cleaner agent purge activity related long running queries.

Database operation took more than the threshold of 500 ms: 35,400 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pr_log_reportstats> <pxCreateDateTime>

Database operation took more than the threshold of 500 ms: 11,427 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pr_perf_stats> <pxSnapshotTime>

Database operation took more than the threshold of 500 ms: 5,951 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pr_sys_statusdetails> <pxUpdateDateTime>

Database operation took more than the threshold of 500 ms: 3,669 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pc_events> <pxupdatedatetime>

Database operation took more than the threshold of 500 ms: 2,755 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pr4_log_rule_usage_details> <pxUpdateDateTime>

Database operation took more than the threshold of 500 ms: 2,697 ms SQL: {call DBO.sppr_purge_table (?,?,?)} inserts: <DBO.pr4_log_rule_usage> <pxUpdateDateTime>

System Administration
Moderation Team has archived post