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 NameBenefitsValue
Automatically grow fileAllows the tempdb database to expand as needed, accommodating cases when the collected audit data set is larger than expectedSelected
File growthAllows SQL Server to efficiently handle any required file growth25%
Recovery ModelAllows you to perform full backups of the Repository databaseSimple
Space allocatedAllows ample database space for audit data collection, so file growth occurs less frequently200 MB
SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels