How can we reduce size of database files.

Products

• Service Virtualization

Issue/Introduction

We keep having to increase volume size of our database servers. Is there a way we can reduce these sizes?

Environment

All supported DevTest releases.

Cause

N/A

Resolution

Please add these properties to the local.properties file of where the Registry is running: (This process is responsible for deleting "expired" report runs from the database.)

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

You will have to restart the Registry to enable these properties. If you want a shorter time period (the default is 30 days), see the below values. I set this to purge anything over 7 days.

perfmgr.rvwiz.whatrpt.expireTimer sets the expiration value of a suite or test. Once a suite or test is older than this value, it is deleted. The property value is a number followed by a suffix. The following suffixes are valid, with t being the default:

t=milliseconds
s=second
m=minutes
h=hours
d=days
w=weeks

Keep in mind that tests and suites are deleted at approximately the same time of day that they were created. Adding several hours can minimize delete processes running during the day. However, there is no absolute way to ensure the times that a delete process runs.

It will take time for the database to catch up and purge all the records.

BEST PRACTICES for DevTest Database Troubleshooting