High Memory Usage

Number of customers complained to us about sudden problems with performance

Background

Package runs every five minutes and it takes 1 minute to complete
Agent is used for execution

Issue

Source database server fails and execution get stuck or packages block each other

• After one hour we have 12 aetlcl.exe stuck
• After 24 hours we have 288 aetlcl.exe stuck
• Eventually the server becomes unresponsive

Solution for the problem

Set Terminate on timeout

Set Execute one action at the time