Page History
...
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 |
| Excerpt |
|---|
SQL Compliance Manager audits all activity on your server. Learn more > > |
...
| Products | Buy | Support | Community | About Us | Resources | Legal