Slow database connections on Windows 8.1
Posted on 2014-09-22
This is a strange one and not easy to explain, so please bear with me :)
I have 2 PC's that were recently upgraded from Windows 7 Pro to Windows 8.1 Pro, both machines are running Visual Studio 2013 and SQL Server Management Studio.
Either when stepping through code in VS that connects to a database (SQL Server or MySQL) or when connecting to a database in SSMS, the operation was quick (less than a second).
After upgrading, the above operations are taking between 5-10 seconds.
I've carried out the same operations on 3rd PC still running Windows 7 Pro and everything is fine (same versions of VS, SSMS and code).. so the common denominator here seems to be Windows 8.1
Has anyone any idea what's happening here and how to resolve?