Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I just installed SP1 for windows 7 and I have severe performance degradation when connecting to SQL Server 2005 since then. Establishing connection takes more than 30 seconds while it's instantaneous on another computer. Firewall is disabled and I didn't make any change to the configuration.

What can cause such a problem?

Thankds in advance!

share|improve this question
    
Try to check for any dns settings and use ip instead of name –  Pitto Mar 8 '11 at 15:51
    
It doesn't fix the problem unfortunately –  Julien Mar 8 '11 at 16:01

1 Answer 1

up vote 1 down vote accepted

To fix, run the following in an elevated Command Prompt:

netsh interface tcp set global autotuninglevel=disabled

Hopefully this is not too late to help.

This is not my answer, it comes from Smiley1244 from the MSDN forums but it is THE answer.

share|improve this answer
1  
It'd be great if you could provide a link for future reference! –  slhck Jun 3 '11 at 17:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.