Answer

PROBLEM

Consider the following situation:

• All employees get in the office in the morning hours and boot up their computers around the same time
• The Outlook Connector of all computers start to synchronize against the GFI Archiver
• This generates a high load on the GFI Archiver server as well as the Microsoft SQL Server
• The Microsoft SQL Server does not recover from this situation automatically after peak hours; you observe slow performance of the system and high CPU and memory usage
• Only restarting the Microsoft SQL Server service does make the resource usage of the Microsoft SQL Server service go back to normal levels

Monitoring the following performance counters (via a Collector Set within perfmon.msc) shows very high values that don't return back to baseline values after peak times:
On the Microsoft SQL Server:

• Microsoft SQL server:General Statistics > Logical Connections
• Processor > % Processor Time

On the GFI Archiver server:

• .NET Data Provider for SqlServer > NumberOfPooledConnections

ENVIRONMENT

• GFI Archiver
• Using Microsoft SQL Server as an Archive Store backend

SOLUTION

• ​When upgrading to a newer version of GFI Archiver, installation files mentioned in this procedure will be overwritten with default versions making the changes void and ineffective. It is therefore suggested to keep a record of this procedure and follow it once again directly after upgrading to keep this functionality intact.
• This procedure requires to edit files manually. If edited incorrectly it can leave the server in a non-operational state. Please keep backups of any file which is edited throughout this article before saving any changes to them.

 

1. Stop all Archiver and SQL services
2. Open the following file in Notepad ..\Archiver\Store\Data\product.config
3. Add the following key within the <AppSettings> section: <add key="MaxPoolSize" value="20" /> 
4. Restart the all GFI Archiver services

CAUSE

The Microsoft SQL Server is unable to handle the load.