Change the following model system database properties to ensure optimal performance and complete backups of the IDERA SQL Compliance Manager Repository databases. The Repository databases store your audit settings and collected audit data. Whenever the Collection Server creates an events or archive database, SQL Server uses the model database as a template for the new database, applying the same property values.
Use the following guidelines to optimize performance in a typical environment. For best results, monitor your audit data collection over a period of time, and then set these model properties to reflect your needs. For more information, see Identify audit data volume.
| Property Name | Benefits | Value |
|---|---|---|
| Automatically grow file | Allows the tempdb database to expand as needed, accommodating cases when the collected audit data set is larger than expected | Selected |
| File growth | Allows SQL Server to efficiently handle any required file growth | 25% |
| Recovery Model | Allows you to perform full backups of the Repository database | Simple |
| Space allocated | Allows ample database space for audit data collection, so file growth occurs less frequently | 200 MB |