Change the following tempdb system database properties to ensure optimal performance when the Collection Server processes and archives audit data.
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 tempdb 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% |
| Space allocated | Allows ample database space for audit data collection, so file growth occurs less frequently | 200 MB |
SQL Compliance Manager audits all activity on your server. Learn more > >
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal