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

Task Manager

Execution Log

Solution for the problem

Set Terminate on timeout

Terminate on timeout

Set Execute one action at the time

Task Manager

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: March 14, 2023