SSMS slow startup March 7, 2008
Posted by furrukhbaig in Performance, slow start, SQL Server 2005, SSMS, Tips.Tags: slow ssms, sql server management studio slow, ssms slow startup
add a comment
Friend of mine asked me “why SSMS is taking up to a minute to startup” on his office machine and I was not able to figure out the problem untill I find the post on Euan Garden’s Blog.
http://blogs.msdn.com/euanga/archive/2006/07/11/662053.aspx
The quick fix is to add following lines in host file
# entry to get around diabolical Microsoft certificate checks
# which slow down non internet connected computers
127.0.0.1 crl.microsoft.com
This is to do with certificate validity check. It fix the problem with my friends machine. Hope it helps others too.
Enjoy !!
SSIS / SQL Server / Performance Tuning 