It is strongly recommended to review the SQL Server specification versus the recommended levels in the Migration Manager for Email Archives documentation.
The following error below may be seen in the EV Collector Module log file. The error concerns timeout from EV SQL, where the EV Collector is collecting journal item metadata from EV SQL server.
The EV Collect module .exe.config file has two settings which can be adjust in order to try to work around this issue.
Change the SQL Command Timeout from 600, to 1200 or 1800. The above entries in the config file would now look like this:
Change the RowsPerPage option to return large batches of data during each cycle. The default value is shown below (near the bottom of the .exe.config file)
Change the value to 250000:
Once these changes have been made, restart the EV Collector Service.