Question
5
Replies
868
Views
Cognizant Technology Solutions
Posted: August 10, 2018
Last activity: August 29, 2018
Closed
SPPR_PURGE_TABLE table huge time
SPPR_PURGE_TABLE store proc at restart time is taking huge time.
following table has multiple million of record and queries are timeing out since long. DBA is recommending to truncate instead of datatime delete. Can we trauncate following cleanup tables? what will bethe impact?
PR_LOG_REPORTSTATS
pr_perf_stats
pr4_log_rule_usage
pr4_log_rule_usage_details
See if systemcleaner agent is running properly. you can truncate data of these tables
Kindly go through Pega Help here to understand these tables usages and about retention of data in perf table:
https://community1.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#howto/howto2/logusagetable.htm