We have an executable program that we have created here at our company specifically for our company. All of the screens,forms, and tables for this program reside on the server in which everyone using the program (approx. 12 users at any given time, sometimes more sometimes less)gets there information from this place. We had a guy come in and retool the program a while back in which he used ODBC for table accessing so that it would make the server do a little more of the processing. Most of our users do keep about 3 to 5 windows up at a time ie a internet browser, 2 instances of the aforementioned program, and a copy of another server based program (located on a different server). I have broken some of the programs up instead of one server serving 3 app's at a time I had some machines that were needed, but not heavily used that I put some of those programs on, after doing this, it seems to have helped quite a bit too. We try to tell our people to restart their computers at least once a day in that our workstations have Win 98 on them. Hope these specs help.
Thanks,
Tim