Version

All

Date

20 Sep 2004

Summary

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.

Resolution

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

HKLM\Software\Argent\ArgentManagementConsole\KEEP_EXECJOB_DB_DAYS

Set to 0. (Default 1).

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