I am having an issue on a network, and can't pnpoint what is the problem.
The server is a powerful machine with SAS RAID10, and the clients access a relatively small flat-file-database accounting database. 10+ users use the program, and there are two switches on the network (unmanaged 10/100).
What happens is that when one user is using the LAN, the application flies. When more users come, the application lags significantly. Disk Access is not an issue.
How could I diagnose where is the problem? I suppose network collisions could cause this, but I am not sure how to check for that.