I am in the process of investigating issues we have been encountering with one of our applications. The application is written in ASP and calls a VFP Com object.

The VFP Com object is written in VFP 6.0 and compiled as a multi-threaded Com object. The VFP Com object does several simple queries to SQL server tables to compile information. The VFP Com object also does a lot of cursor manipulation. The VFP Com object resides on a Web Server.

We have noticed that there are times when the createobject call from ASP hangs when there are several (up to 50) concurrent users on the application at any given time. (With this many users, possibly 3 - 4 calls would be made to the VFP Com object at the same exact time.)

Does anyone have any suggestions as to what may be going on. Is there a limit as to how many threads can be utilized at one time? Is there anything we can do (or any products that we can use) to help pinpoint the problem to make sure that we are not chasing the wrong problem?

Thanks in advance,
Maria