(crossposted to sysadmin)
Dentist's office, Line-of-Business app is all SQL-based. We got a new server (2008 old, 2016 new), and all new computers. Old server was almost a dumb box with SQL Express running, and no Microsoft management. New server is an actual server with Hyper-V, one virtual for Active Directory and actual domain stuff, etc. The other virtual is strictly for the LOB app and SQL Express 2017. Files for the LOB app are shared from this VM. File transfers are quick, but anytime the LOB app pulls SQL data, the entire program hangs. Pingtimes spike during this period.
The first day we had everything running with just one workstation, and the speed was fine. Second day, everything slowed to a crawl with just one workstation, and all that were added. Nothing changed physically on the network, or in software configurations.
Current physical network: -Crappy SOHO Netgear Router (will be replaced soon) ---Server plugged in here --Netgear ProSafe JGS524E (I don't think any management is enabled, but again, even if there is, I didn't change anything) ---All workstations plugged in here.
I haven't done anything with Wireshark, because although I know what to do in theory, I don't have enough in-depth knowledge to know what I'm really looking for.
No comments:
Post a Comment