SQL Server slow access

BMI-IT used Ask the Experts™
Bit of a strange one.

I have a SQL2008 R2 server running under 2008 r2, the server has been in a test environment on a 100Mb switch and working fine while testing. I moved it to a production 1 GB switch with 3 other devices sharing that switch and now the data transfer performance has been reduced, users accessing data on this device have noticed a lot of slowing

The switch is good as are the other units plugged into it, the NIC shows a 1 GB Connection, the switch port shows a 1GB Link, the No errors or bottlenecks are present on this switch.

I cannot understand how moving from slower link to a faster one can cause this issue.

No other servers on the switch as having issues
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

The switch may have reached its backplane threshold.

Check the network interface properties. check the properties of the file and printer sharing.  Which option is selected there? maximize throughput for network applications?

Is IIS also installed on this server, get the mini-speed test from www.speedtest.net and see whether the issue is really network, or the requests hitting the SQL and can not be fulfilled in a timely manner.
The test will tell you what the link throughput is.

use the sql tunning agent to see what can explain the performance or provide suggestion to add indices, etc.?

How big is the database, how much memory in the system? How much memory does sql use?
Did you set the boost SQL priority? SSMS properties of the database server, processor.
Top Expert 2015
Switch is overloaded.
Steve JenningsSr Manager Cloud Networking Ops

Check duplex and speed settings

Good luck,
Top Expert 2015

Are you sure it is me and not arnold\s answer?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial