Version

All

Date

9 Jan 2002

Summary

A client may state the server running Argent is running poorly or that the disks are thrashing on the server.

Technical Background

Often this is caused by SQL Server is running on the same machine and set to dynamically allocate memory.

View the SQL Server process under Task Manager.

If it is using a high percentage of the system’s RAM, do the following.

Resolution

Access SQL Server using SQL Server Enterprise Manager.

Right-Click on the name of the SQL Server itself within enterprise manager, and select Properties.

Access the Memory tab.

Ensure to set SQL Server to use a STATIC memory setting of 20% of the total RAM on the server.

Setting this to Dynamic causes SQL Server to eventually allocate all of the system RAM to itself, thus leaving Argent with no available system resources.

If the production schedule allows it is a good idea to reboot the server.