We went live today with an internet application, written in Visual FoxPro, and using MTS. When the user load increased, the response time ground to VERY slow. Looking at the system monitor, we see that mtx.exe is pretty much pegged at 100%.
A few questions, the obvious first.
1. Any idea what could cause this?
2. How can we monitor what the MTS process itself is spending its time doing?
3. Ideas as to how we might go about troubleshooting the situation.
We don't know how many users are pounding away (how can we find that out, but when we limit the concuurent connections to 50 or 75, the performance improves but users then get our "System Busy" message as they move from page to page.
Sure would like a clue where to start, if not the solution itself. I'm afraid that just adding processor power to the web server may not solve the problem.
A few questions, the obvious first.
1. Any idea what could cause this?
2. How can we monitor what the MTS process itself is spending its time doing?
3. Ideas as to how we might go about troubleshooting the situation.
We don't know how many users are pounding away (how can we find that out, but when we limit the concuurent connections to 50 or 75, the performance improves but users then get our "System Busy" message as they move from page to page.
Sure would like a clue where to start, if not the solution itself. I'm afraid that just adding processor power to the web server may not solve the problem.