August 13, 2013 at 6:27 am
Is it normal for SSMS 2012 to take about 42 seconds to open on a workstation?
Windows 7 Enterprise x64
Intel(R) Core(TM) i5 CPU, M540 @ 2.53GHz 2.53GHz
4.00 GB
SSMS Version 11.0.3128.0
I've applied all Windows updates to my SQL server.
After closing SSMS and re-opening it only takes about 11 seconds. It seems to be the first start-up.
August 14, 2013 at 3:17 am
Interested to know the answer, because this happens for me as well. (I think it being faster on the second run is just because Windows still has a bunch of the files it uses cached in RAM, though).
August 14, 2013 at 3:32 am
By any chance your profile is deleted or different option like citrix or other?
Regards
Durai Nagarajan
August 14, 2013 at 5:22 am
I've had this before when I've had an authenticated proxy server that doesn't allow other applications out over the internet. I think the reason is that SSMS 2008 (not sure about 2012) has some signed libraries that it tries to validate across the internet. Some of the fixes/hacks here have worked for me before. Not sure if it's relevant to 2012 or not, but worth a try.
Although if it opens quickly the second time, sounds like it could be very slow/fragged disks and it's quicker on re-opening as it's cached in memory...
May 15, 2018 at 5:53 pm
Have you checked this?
https://blogs.msdn.microsoft.com/euanga/2006/07/11/faq-why-does-ssms-take-45s-to-start-up/
🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply