KBI 220260 High CPU Usage Of SQL Server




20 Sep 2004


Running Argent with SQL Server might cause the SQL Server to consume a large amount of CPU time.

Technical Background

When running Argent with SQL Server on a limited resource server, the SQL Server process may consume over 90% of the processor.

This can be caused by SQL Server maintaining the AG_EXECJOBS table.

The Argent Guardian main engine inserts a new record into this table whenever a Relator is executed on a server.


This table is only for displaying of the History screen.

It is not vital to monitoring tasks.

Resolve this issue by keeping this table small.

Edit registry


Set to 0. (Default 1).

This will allow the Main Engine to empty this table once every day.