SSMS occasionally freezing/hanging

  • Gents,

    I have a weird intermittent issue with an enterprise version of SS2014. When clicking or right clicking around SSMS will lock up and display the 'SSMS is busy - waiting for an internal operation to complete'. It is only specific to the server as when I connect using my local SSMS this doesn't happen. This was happening both pre and post SP1 install. There is nothing in the logs to point to an issue, and googling around hasn't really turned up anything, any ideas what this could be?

  • Not sure what it is, but I've heard of others having this issue. I haven't seen it myself, so I don't have much advice.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Hi,

    Maybe this couple of articles will help you to troubleshoot the problem:

    Some known issues with SQL Server Management Studio (SSMS)

    http://thesqldude.com/2012/09/13/some-known-issues-with-sql-server-management-studio-ssms/[/url]

    SSMS 2012 freezes when being launched

    http://blogs.msdn.com/b/andreasderuiter/archive/2012/12/18/ssms-2012-freezes-when-being-launched.aspx

  • Ended up being an SSMS add-in I wasn't aware was installed, the context menu for it wasn't even showing up. Deleted it from 'C:\ProgramData\Microsoft\SQL Server Management Studio\12.0\AddIns’ and no more issues.

  • Interesting. Which add in?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply