Response Time using Term Server and Access DB
Posted on 2006-11-08
I have a Windows 2003 Terminal Server with about up to 10 users at a time, licensed for 17. The server is an IBM 206, P4 single processor 3 GHz, with 1 Gig of ram, and Adaptec mirrored SATA hard drives (built into the motherboard - software implementation of raid 1). The users remote into the server and run an access database with a form interface. Usually performance is pretty good with not much complaining. However, sometimes the users "hang" in the middle of using access. They are doing a phone survey that is VERY time dependent; they are tracking down to the 1/10th of a second on items such as rings, answers, responses, etc... The timers have been built into access so they just click a start/stop button for a function. However when the server/network/internet slows down for whatever reason - 5 - 6 second delay, the user has to delete the call and start over. My questions are:
1. Can I guarantee access response time across the public internet for a remote user?
2. If so, where do I start troubleshooting this problem?
Thanks - Wayne