When you install the AppManager repository, you set the initial size of the repository’s data and log files. After installation, you can use the Management Studio to expand the size of the data and log files or add new data and log files for the repository to expand into over time. In planning for repository growth, consider the following:
SQL Server is configured by default to automatically grow the database file size without restriction. NetIQ Corporation recommends that you restrict database file growth so that the database cannot consume all of the disk’s resources. If the database consumes all available disk space, you cannot perform any maintenance on it, including deleting or truncating data.
If you allow SQL Server to grow automatically, you will experience some performance degradation while SQL Server is in the process of expanding the database.
You can reduce disk fragmentation by configuring the database file size to expand in larger increments.
Increasing the size allotted for the data file or adding data files before a significant amount of information is stored in the repository helps to maximize performance.
To expand the size of a QDB, first increase the size of the database data file. For information about how to increase the size of the data file, see your SQL Server documentation.
You can also expand the size of the existing log file or add new log files for the repository. For information about setting a new log file size or adding a log file, see your SQL Server documentation