This is releated to the open question I posted earlier: http://www.experts-exchange.com/Operating_Systems/Windows_Server_2003/Q_21384401.html
The server is hosting two applications, Chiro800 and AutoDoc. Chiro8000 uses Pervasive's SQL workgroup manager, and AutoDoc uses a btreive solution. Both require that I share their DB folders, which the clients then need to have mapped.
AutoDoc use to be hosted on a Windows XP home PC. Since I moved it to the server, it's three times slower, taking about 10 seconds to load forms.
I attempted to change the Hardware performance options to give processing and memory priority to background services. But that didn't help, appears to have made it worse.
I have the specs in the link. But I don't think it's a CPU or memory issue, as task manager barely registers when the clients are workng. I can't help but think it's the cheap switch they are using. Someone suggested forcning the nics to use full duplex. The Server and PC's are all showing 100 MBPS.
Many thanks for any suggestions