SSMS 2012 freezes when being launched


I just spent 30 minutes on SSMS which hanged on me every time I tried to launch it. I searched the Internet but couldn’t find a solution. The SMSS process was heavily using the CPU and slowing down the machine, but after the splash screen the SSMS application window wouldn’t appear.

Then I downloaded Process Monitor, saw that the process was continuously using a file called C:\Users\username\AppData\Local\Microsoft\SQL Server Management Studio\11.0\1033\Ssms.CTM.

image

I killed the SSMS process, renamed the Ssms.CTM file, and launched SSMS again. Problem solved!

Update:

In the comments section, plectoBne provided an alternative – and probably better – way to solve this issue. His suggestion is to rename

[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio] (this is a registry key which you can edit with RegEdit.exe)

and

c:\Users\<profilename>\AppData\Local\Microsoft\SQL Server Management Studio\

and let SSMS create a new Environment

Thanks plectoBne for sharing! 

Comments (10)

  1. plectobne says:

    could also be a misconfiguration…

    just rename

    [HKEY_CURRENT_USERSoftwareMicrosoftSQL Server Management Studio]

    and

    c:Users<profilename>AppDataLocalMicrosoftSQL Server Management Studio

    and let SSMS create a new Environment

  2. Anonymous says:

    Thanks! The above resolved my issue.

  3. Shanky_621 says:

    IMHO article is incomplete unless you show step by step how you configued procmon. I say so because this would help nebies and adecate them how to use procmon to get around with such issues.Anyways thanks for posting

  4. Shanky_621 says:

    Please ignore prev comment it has typo

    IMHO article is incomplete unless you show step by step how you configued procmon and how you found out  the issue. I say so because this would help newbies and aducate them how to use procmon to get around with such issues.

    Anyways thanks for posting

  5. Anonymous says:

    @plectoBne, thanks your suggestion worked for me.

  6. Anonymous says:

    Thanks for your help plectoBne  this worked for me as well

  7. Anonymous says:

    Thanks for the help it worked for me also. @PlectoBne

  8. Anonymous says:

    @plectoBne, you rock.  Thanks.

  9. Anonymous says:

    Thanks, @PlectoBne, this saved me a lot of time & trouble!

  10. GAMA_ says:

    Thanks ,@PlectoBne … it really help to fix it