SSMS - Experiences Random Hanging - by Kurt Moskal

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 716805 Comments
Status Closed Workarounds
Type Bug Repros 11
Opened 1/5/2012 10:42:28 AM
Access Restriction Public


SSMS - Experiences random hanging. I've experienced random hanging, plus slow response when using SSMS for SQL 2012.  The hangs are very random and I've never been able to reproduce them. However in all cases, during the hang, SSMS displays a balloon help stating that Management Studio is busy and to try the step again later.  The slow response is mostly in Object Explorer. For example, I'm seeing 20 to 30 secs when trying to open the list of databases. In comparison, SSMS for SQL 2008  opens a similar instances in under 3 seconds.

In general it appears that SSMS has not received enough attention in this release.   
Sign in to post a comment.
Posted by Sethu Srinivasan on 8/7/2012 at 11:03 AM
Thanks for reporting this issue.

Could you please capture full process dump and share with us?. this could help us investigate this specific issue

You could follow the link below to automatically capture full process dump whenever a process crashes

Sethu Srinivasan [MSFT]
SQL Server
Posted by it-santos on 6/7/2012 at 1:50 AM
I have the same Problem (Message "SSMS is busy" forever). It is often when i do the following:

- Work with the SSMS
- Start the Internet Explore (SSMS is in Background) and work on our Websites
- switch to the SSMS
Posted by Microsoft on 5/22/2012 at 12:19 PM
Hi Kmoskal
Thanks for writing in with this issue. We have continued to investigate, but can no longer reproduce the issue. Please reopen this bug if you encounter some specific repro steps.

Posted by NdiliMfumu on 4/25/2012 at 11:19 AM
Further news: The problem I've been experiencing did not ultimately resolve with closing ObjectExplorer, but only after turning off AutoRecovery at the Environment Tab of SSMS 2012. I've been able to open ObjectExplorer and use IntelliSense without difficulty, since then.
Posted by NdiliMfumu on 4/25/2012 at 8:58 AM
Same problem: Using SSMS 2012 with Object Explorer open to a single SQL 2008 R2 server, and while writing some complex T-SQL code in the Query Window, the memory utilization ujnder Task Manager of the Ssms.exe*32 executable climbs incessantly, often exceeding 1 GB. Closing Object Explorer causes the memory to be released. Definitely a bug.
Posted by Yakovma on 3/19/2012 at 7:20 AM
here is the message from ssms after a lot of time:
Problem Event Name:    APPCRASH
Application Name:    Ssms.exe
Application Version:    2011.110.2100.60
Application Timestamp:    4f35e2d9
Fault Module Name:    StackHash_78bf
Fault Module Version:
Fault Module Timestamp:    00000000
Exception Code:    c000041d
Exception Offset:    74e44cad
OS Version:    6.1.7601.
Locale ID:    1037
Additional Information 1:    78bf
Additional Information 2:    78bfd0f302ca49e7ecf0bde4b5e748d5
Additional Information 3:    af9a
Additional Information 4:    af9ac6a83ece7050c27894ff55585880
Posted by Yakovma on 3/19/2012 at 7:10 AM
I Install sql 2012 RTM and i have the same problem, SSMS hang!!!!
Posted by DBA-Don on 3/7/2012 at 4:55 AM

I am also experiencing this issue and it is very frustrating as your query tabs do not recover after the crash thus if in the middle of creating a proc etc you have lost the work..... :(

Running a i7 with 8GB of RAM....
Posted by Microsoft on 2/16/2012 at 12:45 AM
Hi KMoskal and TechMgr1,
Thanks for reaching out to Microsoft.
We have investigated the issue and identified a couple of places where SSMS was performing quite slow and would appear hung. These two issues have been fixed and will be available in the next public release of SQL Server 2012.
If you still experience slowness / hang issues when the fix becomes available, please get back to us with more info on the machine configuration, scenarios etc so we can dig further.

We appreciate your valuable feedback.
Posted by TechMgr1 on 2/1/2012 at 6:46 PM
I would add that this is happening on a beefy laptop Quad core i5 with 8 GB of RAM. Never had this issue with CTP3. This is definitely something that has been introduced in RC0
Posted by TechMgr1 on 2/1/2012 at 6:44 PM
I have the exact same issues. When using the query editor and typing a query SSMS hangs preventing any type operation and returns to normal after a few seconds as long as about 10 seconds. It cannot be deemed as random since it is very pervasive. The only thing random about the hang is the wait time which ranges from 1 to 2 seconds to almost 10 seconds. It almost seems like SSMS is trying to do an active keytype prediction or validation that is causing this hanging behaviour. very frustrating and hardly usable SSMS.