Registry Database is getting heavily used and its running out of disk space

book

Article ID: 131871

calendar_today

Updated On:

Products

CA Application Test Service Virtualization CA Continuous Application Insight (PathFinder) CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

The registry database is growing by up to 10 GB daily.
What could be causing this usage and how can this be reduced.

Cause

One common reason for the SQL Server registry database taking disk space is that many tests are being run that produce a report.
In that case most data will be used by tables that have a name starting with HST_
If most space in the database is used by the table LISA_FRAME_DATA, then the growth is caused by the CA Application Insight component. 

Environment

Release: MSPSVF99000-10.4-Service Virtualization-Functional Transactions-MSP
Component:

Resolution

One common reason for the SQL Server registry database taking disk space is that many tests are being run that produce a report.
In that case most data will be used by tables that have a name starting with HST_
The tests may use a staging document with the 'Default Report Generator'. 
Sometimes tests have been configured to run in CVS. 

If this is the case the following strategies can be used to reduce the usage: 
In the staging doc use the 'Load Test Report Generator' instead of the 'Default Report Generator'. 
Run the report cleaner more often than the default of 30 days. 
Configure the following in local.properties: 
perfmgr.rvwiz.whatrpt.autoExpire=true 
perfmgr.rvwiz.whatrpt.expireTimer=5d 

If most space in the database is used by the table LISA_FRAME_DATA, then the growth is caused by the CA Application Insight component. 
This is also known as CAI or Pathfinder. 
If this module is not required, stop the broker and to set the following in local.properties: 
lisa.pathfinder.on=false 

Removing old records from the database is done automatically by the broker. 
The default age for deletion is 7 days. However, this value can be adjusted using this property in the <broker> section of rules.xml: 
<property comment="Age of transactions that should be deleted when the clean runs [minutes old] 7200=5 days" key="lisa.pathfinder.transaction.cleaner.age" value="10080"/> 

After turning of Pathfinder for 10 days, just turn Pathfinder and the broker back on temporarily.
This should then remove the expired records for CAI.

If you are using SQL Server to store the registry database, you could "shrink" the database in Management Studio of SQL Server to return the data back to the OS.

Additional Information

For background on database maintenance see: 
https://docops.ca.com/devtest-solutions/10-4/en/administering/database-administration/database-maintenance 

For background on CAI see: 
https://docops.ca.com/devtest-solutions/10-3/en/using/using-application-insight 
https://docops.ca.com/devtest-solutions/10-3/en/agents/devtest-java-agent/transaction-dispatchers