Question

4
Replies
688
Views
Close popover
Anoojit Dhar (DHARA001)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
DHARA001 Member since 2006 8 posts
Cognizant Technology Solutions
Posted: September 18, 2015
Last activity: September 18, 2015
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