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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
mrmutAuthor Commented:
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.
Gerald ConnollyCommented:
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
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

mrmutAuthor Commented:
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.
Kamran ArshadIT AssociateCommented:

You can check the bandwidth using IPerf between the user and server. Below is a nice tutorial;

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mrmutAuthor Commented:

I am still testing, will use this tool too!
mrmutAuthor Commented:
Hello all,

   in the end the problem seems to be a switch. I replaced it, and all works fine.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.