Question
Increasing the retention period of pr_perf_stats table
Hi,
we have a requirement from the Client IT Ops team to increase the retention period of the pr_perf_stats table from the current default value of 30 days to 180 days. As far as I know this table is much like the History table for the application work entities, and it grows exponentially in case of single/multi node systems. Is there any possible impact of such a change on the eventual performance of the Database and/or the application like transaction logs getting full or system performance getting degraded?
pr_perf_stats table contains PAL data for every requestor on every node connected to that rulebase. More details can be found here - https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#howto/howto2/logusagetable.htm along with how to change retention days.
There is a lot of data in this table and this could impact performance if you use the reports that go against this table or your nodes are being monitored by AES (https://pdn.pega.com/products/autonomic-event-services-enterprise-edition) or PDC (https://pdn.pega.com/products/pega-predictive-diagnostic-cloud).