Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SSMS 2012 crashes quite often...

Author  Topic 

Cowski
Starting Member

30 Posts

Posted - 2013-06-25 : 15:58:09
I just started working at a new company. I'm coming from SQL Server 2008 and this company is running Microsoft SQL Server Management Studio 11.0.3128.0.

At least 5+ times a day it crashes with the following error results:

Problem signature:
Problem Event Name: BEX
Application Name: Ssms.exe
Application Version: 2011.110.3000.0
Application Timestamp: 5081c1cd
Fault Module Name: StackHash_0a9e
Fault Module Version: 0.0.0.0
Fault Module Timestamp: 00000000
Exception Offset: 4d83f04d
Exception Code: c0000005
Exception Data: 00000008
OS Version: 6.1.7601.2.1.0.256.1
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789





My manager says "Welcome to SSMS 2012' memory leak." and says not much he's been able to find to do about it. I thought I'd just look to be proactive about it.

Has anyone else encountered this with 2012?? If they have, do you know of a fix?

Thanks!!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-06-25 : 16:24:35
I don't have any issues with SSMS 2012 crashing, and I'm running it on lots of different machines. Perhaps you should try installing SP1 and the latest CU?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Cowski
Starting Member

30 Posts

Posted - 2013-06-26 : 08:55:44
We're on the latest & greatest. v11.0.3128.0 I've tried running the CU but it won't run because it says I'm on the latest & greatest. I did a repair to see if this fixes it. If not, I'm wondering if a uninstall/reinstall could fix it?
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-06-26 : 10:21:02
Not exactly a useful suggestion to solve your problem, but in case it will add anything to the puzzle:

I am using exactly the same version, and I use it all day without any issues problems - no crashes, no freeze ups. So I am suspecting that it may be the interaction of some other software - antivirus, provirus (aka virus), other software etc. that is causing your crashes.
Go to Top of Page

lfagetti
Starting Member

1 Post

Posted - 2013-07-09 : 10:07:40
I have the same problem.
Here is a detail that may help:
After installing SQL2012 I had to install VS2010 SP1 to be able to interface with TFS 2012 (it seems that the VS shell coming with SQL 2012 is not sufficient to handle the TFS add-in).
I did not work much in SSMS before the VS2010 install, therefore I cannot say with certainty that the problem was already existing or not.



Go to Top of Page

Cowski
Starting Member

30 Posts

Posted - 2013-07-09 : 12:18:06
Good afternoon, all!!

I think I discovered what my problem was. Wasn't SSMS 2012 at all. Turned out to be a add-on from APEXSQL called "ApexSQL Complete". It's a rather robust, free, intellisense add-on I tried. It has more bells & whistles than what is built into SSMS. I uninstalled that and <knock on wood> haven't had an issue since! It's been well over a week.

Thank you to all that replied to this thread! Hopefully this will help someone else in the future.


Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-07-10 : 19:06:20
Glad you got it sorted. Have used ApexSQL in the past but don't currently have it installed.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

xyvyx
Starting Member

6 Posts

Posted - 2013-09-03 : 16:37:16
Yeah, I'm having similar issues. In my case, I thought maybe the RedGate plugins were causing some sort of instability... and perhaps they were. I removed all 3rd-party add-ins to SSMS, un-installed & re-installed SSMS. For a while, it WAS more stable! I've been using the 2012 SQL tools for just over 3 weeks without a crash! Anyway, it tanked again today. Luckily, I'd saved my work... I mean, one gets in the habbit when the application you use most and rely on becomes the most unstable too in your arsenal.

I submitted some minidump files to Walter Jokiel & Charles Gagnon based on the following post:
https://connect.microsoft.com/SQLServer/feedback/details/770754/sql-server-2012-management-studio-crashes



"If we can put it into a table, we can kill it"
-Ahnold Sequelnator
Go to Top of Page
   

- Advertisement -