>>The transaction server is running on its own machine with 2 4GB drives striped, 128MB RAM. The TS VFP app is running serveral DLL's that construct queries and direct traffic to and from the SQL Server machine.
>>
>>Just this morning I set the foreground for SYS(3050) to 65536000 and we are running some tests now. But we have to test in the production environment so it going quite slowly.
>
>Sorry, I must really be dense today. I don't understand how tweaking memory on your VFP app (running on other machines?) can effect CPU usage on your separate TS machine.
That may be because the VFP app is running on the Transaction Server. It is an app that runs several DLL's to access the SQL Server, which is on another machine.
:-)Bob
Database Development Team