Marcia --

Have your client install and run the free MS Performance Wizard on the server. It shows you real-time any aspects of the system you could possible want to know, and it also creates a log file for you to look at after the fact.

Here's a good article on what to look for and how to configure the wizard for that http://www.windowsnetworking.com/articles_tutorials/Windows-Server-2003-Performance-Tuning.html.

The most likely candidates are pagefile problems, memory limits, memory leaks, network load and a few other various and sundries. This at least gives you some quantifiable data with which you can start your hunt for the culprit.


>Hi All.
>
>I have a client who has been running a Visual Foxpro application that I wrote for him since 2005. He tells me that occasionally, parts of the program slow to a crawl. The place where he notices this the most is when he is importing files. Some of these tables can get rather large and the information in these tables is checked against records in lots of other tables as they are being processed. He also says that when this occurs, the VFP application's use of memory spikes.
>
>The goofy thing is that the problem will mysteriously disappear and the system will be as zippy as ever for 8 months or so and then the problem occurs again for no apparent reason.
>
>He re-booted his server and it did not make any difference.
>
>BTW, the application is being run using Terminal Server.
>
>Anyone ever experience anything like this?
>
>TIA