The InterviewerSyncSessions table records synchronization session information. The size of this table can grow quickly when many interviewers are synchronizing.

Expired records are deleted when you use the Remote Administration activity. If you do not use Remote Administration, you can delete expired records by scheduling the sp_DeleteExpiredInterviewerSyncSessions stored procedure.

The sp_DeleteExpiredInterviewerSyncSessions stored procedure deletes any entry from the InterviewerSyncSessions table that has a StartTime earlier than the current time minus the InterviewerSyncSessionDataExpiresInDays DPM value. The stored procedure also deletes any rows from the other tables that are associated with deleted sessions in the InterviewerSyncSessions table.

For more information, see UNICOM Intelligence Interviewer - Remote Admin Interface.