How can I estimate Database Size for ChangeAuditor? (4234162)

There is a need to know how much space the database will need so Drive Space can be appropriated correctly.

Database size greatly relies on the environment and the scope of what is being audited. 20-40GB per year is a good start for an average database size. This can however change drastically for each environment.

The best way to see how much space an environment will need for the ChangeAuditor database is to setup auditing then monitor growth over the period of a few weeks to months.

Please note that with Change Auditor 6.5 and higher, the TempDB database, one of the default SQL databases, will be heavily used when running automated purge jobs or scheduled reports.  Please allow 100GB of drive space for TempDB.  Ideally, the TempDB should be isolated to it's own drive on the SQL server.