troubleshooting Question

SQL Server slow access

Avatar of BMI-IT
BMI-IT asked on
Apple OSNetworkingWindows Server 2008
4 Comments1 Solution356 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros