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.
|Automatically grow file||Allows the ||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|