Question

4
Replies
667
Views
DHARA001 Member since 2006 8 posts
Cognizant Technology Solutions
Posted: 5 years ago
Last activity: 5 years ago
Closed
Solved

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?

System Administration
Moderation Team has archived post
Share this page LinkedIn