I have a 2012R2 Server, it is currently on two GB NICs Teamed, one of the bespoke software is really old, more like a Btreive type flat DB and it is currently holding over 1 Million + records.
We have 30 workstations, and while we know the software is either badly written or it is generating a lot more traffics than a standard SQL, we need to find a way to ‘fix’ this.
The server is a Xeon 3.3GHz/16GB/4x1GB on Adaptec RAID10 (Avg read/Write is 250-350Mbps)
I added the second NIC to team few months ago after yet another software update that added even more weight to the already slow software, before anyone say change software, we simply can’t because this is a bespoke system with 20 years of data which the supplier said they can’t migrate to SQL yet, and may not be a few more years.
I can see the bottleneck coming from the traffics as during peak time (when users start to moan about snail pace speed), the CPU is at 15%, Memory at 20% and the server still responding to commands at normal speed, but the Sent traffics is around 30Mbps to 50Mbps but can peak to 140MBps for a short burst of time. The Recv traffics is normally around 15-30Mbp during peak and will die down around 2-5Mbps.
Before I added the second NIC to team, the system for most if not all users can be locked in a freeze state for a minute or ...