CA UIM database has grown by 30 GB in a single day

Article Id: 37983

Status: Published

Updated On: 14-02-2018 07:36

Legacy Id: TEC1710716

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) , NIMSOFT PROBES

Issue/Introduction:

Problem:

SQL Server Transaction logs growing rapidly (30 GB in a single day)

Environment:

UIM 8.31
DB - MS SQL 2012

Cause:

The transaction log file is maintained by Microsoft to enable a rollback of the database should a major database failure occur.

Resolution:

Set the UIM database Recovery model to Simple

Deactivate the NAS and Data_engine probe.
Modify the NAS.cfg file to reduce the retention period :-

transactionlog_compress = 1
transactionlog_age = 1
transactionlog_summary = 1

Modify the data_engine.cfg to delete historical Data older than from 72 days to 10 days

Activate the NAS and Data_engine probe.

Additional Information:

If you cannot use Simple recovery model you will need to make sure your backup process is check pointing the log file and clearing transactions. If you only backup once a day the log file will grow all day long and then be cleared during the backup process. Keep this in mind as you see that file increase in size.

Environment:

Release: CNMSPP99000-8.31-Unified Infrastructure Mgmt-Server Pack-- On Prem
Component: