This is a weird one. I have three switches:
1. Catalyst 2950 (100 meg with 1000Base-SX uplinks)
2. Catalyst 500 (100 meg with 1000Base-SX SFPs)
3. Catalyst 500 (gigabit)
Switches 1 & 2 are uplinked via 1000Base-SX, switches 2 & 3 are uplinked via 1000Base-T
The server farm (including a dedicated MS SQL server) is connected to switch 3.
Workstations connected to switch 1 experience normal connectivity to the SQL server but when connected to switch 2 are experiencing slow performance. It only appears to be with SQL server packets as other application level packets (e.g. SMB) appear OK. Lower layer connectivity appears to be working fine. Smartports on both switches are configured as workstations.
Can anyone shed any light on why SQL server connectivity from switch 2 is so slow?