Question

2
Replies
190
Views
PradeepPydi Member since 2017 202 posts
Anthem
Posted: 2 years ago
Last activity: 2 years 7 months ago
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
Share this page LinkedIn