Question

4
Replies
696
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.