Gathering tasks fail with errors similar to the following:
"Task has failed with error message = [System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
"The following error occurred during the processing of a given gathering: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
SQL Queries are Timing out on the Database Server. This can occur if there are other SQL jobs running at the same time as the gathering tasks cuasing timeouts when trying to write to the database or execute stored procedures
Check the SQL server where the MessageStats database is hosted to see if there are other SQL activity or jobs running at the same time that the gathering tasks are running that may interfere with the tasks completing in a timely fashion. If so, schedule the gatherings or other SQL activity so that they do not overlap.
For example. The Data Aging, Reindex and Defrag jobs should be run when there are no other gathering tasks running.
