LAN server access problem diagnostics (windows 2k8)
Hello all,
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.
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.
You should use the System monitor tool which is included in Windows, there you can record activity over a long time and see how much RAM, Disk IO, CPU etc is used. If you can't find any bottleneck during these "lag" situations it means that the application is simply programmed in a poor way. With database related applications it might also be worth looking into the database itself, generally speaking you often have extreme "lag" when deadlock situations occur.
ASKER
I just called the co that produced the software and they told me that the database could be skimpy, but with hundreds of users, not with a dozen.
Will try testing this friday.
Will try testing this friday.
So you only have a 10/100 switch that's 10Mb/100Mb = 1MB/10MBps
You will probably only get 5MegaBytes per second per link. That may be why one works but more than one sharing that kind of bandwidth doesnt
You will probably only get 5MegaBytes per second per link. That may be why one works but more than one sharing that kind of bandwidth doesnt
ASKER
Yeah, that's the other option.
I've tested today with a gigabit switch and that seems to improve situation. However I am still not completely sure, as I had little time to do testing - I have arranged more testing next monday.
I've tested today with a gigabit switch and that seems to improve situation. However I am still not completely sure, as I had little time to do testing - I have arranged more testing next monday.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
I am still testing, will use this tool too!
I am still testing, will use this tool too!
ASKER
Hello all,
in the end the problem seems to be a switch. I replaced it, and all works fine.
in the end the problem seems to be a switch. I replaced it, and all works fine.