Estimate the amount of audit data your compliance needs may generate, and ensure the Collection Server computer has ample memory and database space. Consider the following examples:

  • A data set of one million events may require 1 GB of database space to store the audit data
  • A trace file that is 5 MB may require 100 MB of memory to process the collected events

The amount of audit data you collect and process depends on your audit settings. Test your audit settings to identify a baseline and set your memory and hardware needs accordingly.

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.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels