The ITPAM database mdf file along with the transaction log become large.
ITPAM makes heavy use of the database, it is not unusual for production usage to utilize gigabytes of database space in a relatively short amount of time, and we have seen IT Process Automation utilize over 500GB of disk space in production environments.
Understanding how ITPAM utilizes the database can help you prepare for, as well as minimize this usage as much as possible.
ITPAM has three distinct schemas.
Library:
Administrators can delete them from the configuration browser or though other direction SQL means.
To keep things small, it is important to understand what is growing:
Queues:
Reporting DB:
For SQL Server:
Please also see the help for "How Does Shrinking the Log File Work?". Please discuss the below with your DBA first.
Turn the DB recovery model from full to simple
Shrink the DB (using shrink-file operation detailed in SQL help topic mentioned above)
Issue "checkpoint" command (commit)