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 |