I inherited a haphazard network that I'm in the process of cleaning up and modernizing.
Here is a synopsis of the current issue:
We have a MySQL DB hosted on a Windows 7 PC (solely used to host the DB).
The PC is in the same subnet as our users AND our servers...
A DNS CNAME/Alias was created for the PC, so users type "voucherlog.xxxxxxx.org into their browsers to pull up the DB's Drupal interface.
DB performance has diminished greatly (slow to the point of non-responsive).
The DB engineer has performed maintenance on the DB and is convinced that performance issues are due to network issues (packets being dropped, jitter).
Pinging internal devices results in a packet loss percentage of 0 (but I'm still going to see how the networking devices are configured).
Pinging www.google.com or 18.104.22.168 can result in packet loss of around 10%, but it appears that packet loss occurs between our router and Comcast's equipment (50.203.245.xxx) (see WinMTR screenshot below).
1) Based upon the diagram below, no internal traffic should go through the router, yes? The switch's MAC address table should handle frames between PCs. I looked through the router's traffic log and I didn't see any internal-to-internal entries, just stuff between our router and Comcast, etc.
2) I read that the hop count in a tracert is the number of routers that the data passes through and that switches do not impact the hop count. If a tracert is done from one PC to another (same subnet), it shows 1 hop. This doesn't mean that it went through the router, does it? It should only pass through the switch, yes?
3) Since the DB is hosted locally, our external packet loss issue with Comcast (which will be addressed regardless) should not be impacting DB access. Unless there's something I'm missing... I'm not terribly familiar with DB design/hosting, but the PC that the DB is hosted on is running Apache and MySQL and the data is saved to the PC, so we should be able to access the DB even if our Comcast connection is down.