>>I am running a 3-tier VFP/Transaction Server/SQL Server 6.5 application using Windows NT 4.0 on all four tiers. It seems that some queries (and even some pretty simple ones) tap the CPU on the Transaction Server at 100%. It seems that SYS(3050) might help here, but without knowing how to divide the 128 MB RAM, I would have to do trial and error. Is there are source where I can find recommended ratios for SYS(3050)? Or can someone give me an intelligent recommendation?
>>
>>Thanks,
>>Bob Byrd
>
>You might try experimenting with different values of the foreground buffer. When VFP first comes up its likely to be in overcommit as to its possible size. One of the reasons that its recommended that the buffer size is reduced on NT Server is that VFP assumes the available memory at the time of loading is completely available.
>
>To find out how actual physical memory varies during the application's execution you can download my prototype Buffer size tuner and mess around with the watermark property.
>
>I'd be interested if it helped at all in you tuning your application if you use it.
>
>Simon
Thanks Simon,
You are the first person to actually address my question! And boy do I appreciate it.
How do I find your prototype Buffer size tuner and download it?
Bob
Database Development Team