Page History

...

To estimate your audit data volume, perform a test audit of your SQL Servers for 7 days, and track how much space is used by the Repository databases. Use the resultant event collection rate to estimate the database size you will need to store and process audit data over time. Also consider how often you plan to archive or groom data. For example, if you collect an average of 500 MB of audit data per day and you plan to archive events every 14 days, then the database size should be set to 7 GB. Ensure you set the Repository databases to automatically grow. For more information, see Optimize tempdb settings.