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 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%
Space allocatedAllows ample database space for audit data collection, so file growth occurs less frequently200 MB

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels