2

Our database server is a SQL 2008 server.

My colleagues all have XP service 2 installed with Sql 2008 Management studio and they have absolutely no performance issues.

I however am running Vista x64 (Ultimate) and when I open the 2008 Management studio it's impossibly slow. It takes almost 25 seconds to just connect to the database, so when I run certain portions of our code against the database I more often than not get timeouts.

Everything else on this machine is running like a dream! Is there an issue with SQL2008 on Vista x64 communicating with SQL2008 on a Windows 2003 Server?

Thanks

Cade Roux
  • 88,164
  • 40
  • 182
  • 265
StevenMcD
  • 17,262
  • 11
  • 42
  • 54

1 Answers1

3

Nevermind, I have my problem while asking the questions.

Vista has a TCP/IP auto tuning feature. By following this tutorial: http://www.vistax64.com/tutorials/72308-auto-tuning-tcp-ip-receive-level.html I disabled it and now everything runs like a dream!

StevenMcD
  • 17,262
  • 11
  • 42
  • 54