Sql 2008 exceptionally slow in Vista 64

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

Answers


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!


Need Your Help

how to simulate correlated binary data with R?

r binary simulation correlation

Supposing I want 2 vectors of binary data with specified phi coefficients, how could I simulate it with R?

Image format and unsigned char arrays

c++ image arrays byte imaging

I'm developping imaging functions (yes I REALLY want to reinvent the wheel for various reasons).

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.