DevTest Registry Database Tuning Using Report Cleaner

Document ID : KB000095313
Last Modified Date : 09/05/2018
Show Technical Document Details
Introduction:
DevTest Registry Database Tuning Using Report Cleaner to only keep 7 days worth of data.
Environment:
All supported DevTest releases and platforms.
Instructions:
In order to keep your database under control and only needing a weeks work of data, set these properties in the local.properties file to these values: 

perfmgr.rvwiz.whatrpt.autoExpire=true 
perfmgr.rvwiz.whatrpt.expireTimer=7d 

Also Do regular Database Maintenance. Make sure your database has regular maintenance which includes checking for signs of corruption in the database, looking for problem areas, verifying it has all the required indexes (compare to DDL delivered with release), removing duplicate records, making sure database is not getting full and checking for any abnormalities in the database that might signal a problem. Run statistics regularly.