I have a simple network built using:
- 1 Switch (16-Port Gigabit Easy Smart Switch)
- 4 Windows 10 PCs (Used as kiosks, with a custom software application)
- 1 Windows 10 PC (Used as a SQL Server)
- 10 custom boards (They respond to ARPs, ICMP, and send small data across the network)
All the PCs and boards are setup with static IP addresses and the PCs have an extra adaptor that connects them to the internet (Edit on different IP address ranges and subnets).
Within my application I'm intermittently getting an error: a network related or instance specific error occurred while establishing a connection to sql server. the server was not found.
I believe there is some sort of instability/high utilisation going on within the network but can't for the life of me figure out how to diagnose it?
What steps can I take or tools can I use to find out the root cause of this issue?
Edit: Both networks are on different subnets and IP Ranges (192.xxx and 172.xxx - We use the 192 network for custom boards, 172 for internet)
Edit: I've tried using Wireshark to attempt to find a bottle neck in the network but I don't know what steps to take to setup and monitor the throughput or utilization.
Wireshark
(free to use)! With its help you might be able to determine the answer to some of your questions.