An administrator observed his agents connected and sending current data to the Coordinator, but running a search for activity in the last 30 days did not include events for the last two weeks.
The Windows Event Viewer Application log on the SQL server showed the following error:
Autogrow of file 'ChangeAuditor' in database 'ChangeAuditor' was cancelled by user or timed out after 33 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
The best solution is to maintain the database size proactively and not rely on the Autogrowth function. Manually increase the size of the database to accommodate anticipated growth with an extra 20-30% as a safety net.
Alternatively use ALTER DATABASE to set a smaller FILEGROWTH value.
To change the AutoGrowth property: