Partager via

SSMS 2012 freezes when being launched

  • Article

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

  • Anonymous
    March 20, 2014
    could also be a misconfiguration...just rename[HKEY_CURRENT_USERSoftwareMicrosoftSQL Server Management Studio]andc:Users<profilename>AppDataLocalMicrosoftSQL Server Management Studioand let SSMS create a new Environment
  • Anonymous
    June 03, 2014
    Thanks! The above resolved my issue.
  • Anonymous
    July 13, 2014
    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
  • Anonymous
    July 13, 2014
    Please ignore prev comment it has typoIMHO 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
  • Anonymous
    September 28, 2014
    @plectoBne, thanks your suggestion worked for me.
  • Anonymous
    November 04, 2014
    Thanks for your help plectoBne  this worked for me as well
  • Anonymous
    December 17, 2014
    Thanks for the help it worked for me also. @PlectoBne
  • Anonymous
    April 10, 2015
    @plectoBne, you rock.  Thanks.
  • Anonymous
    April 14, 2015
    Thanks, @PlectoBne, this saved me a lot of time & trouble!
  • Anonymous
    September 11, 2015
    Thanks ,@PlectoBne ... it really help to fix it